Multiple Occurances in Combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo that goes through and selects all projects from a table that
are being worked on by a particular employee who is selected from another
combo. Now this is working as expected however I seem to be getting 3
occurances of the same project in the drop down menu. say for instance i
select "1. Richard" in the employee box i then go to the combo with the
projects he is working on and the menu has:

Project B
Project G
Project B
Project G
Project B
Project G

this is despite the fact there is only one occurence of each project in the
table.

I'm a bit stumped on this as i have no such troubles with similar cascading
combos.

any help would be greatly appreciated.
thanks
 
Back
Top