Hi.. hello everybody,
im still a freshman in this area,

im currently developing a training system where user keyed in details of staff undergo trainings selected by my company.

yesterday while i finalizing my system, i realized that when i try to update one data based on the user id and the course name, when i view back all the courses, it will list out the same course more than once based on how many updates that i made for each course.

for example, at first it will show like this

course name | the details...

A
B
C


then, for each course there might be more than 1 user(s) so let say for course c, i have 3 staff enrolled into it. when i update one data of the staff in C, the previous example will be shown like this

course name | the details...

A
B
C
C

and both C's have equal data. and when i checked in the database, there's no duplicate data. and it updates the data exactly only at the part that i'd change. so what went wrong??

thanks for helping me out.

regards;
Aslina

Hi,

This is most probably due to the JOIN between your tables in the recordset.
Check the difference between INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN.
Also check SELECT DISTINCT statement to prevent records to be displayed more than once...
I guess it lay there.

Greetzz,

Wim

Wim Conix
www.image-belle.com