Combo box

[MarkV]

Hello, I have 3 combo boxes with the same Engineers names in them from a table called Engineers. However I have a Lead Engineer and Backup 1 Engineer and Backup 2 Engineer. Is there a way I can say if a user selects a name called John B as a Lead Engineer, that it is not allowed to be the same in the Backup 1 or Backup 2. All 3 have to different names. Cant have the same name in any of the 3.

Thank You
Mark

[ItsMe]

Are you asking about Cascading Combo Boxes?

[MarkV]

I have no clue cascading. I put 3 separate combo boxes coming from same table and entering it in the table as a foriegn key (number)

[June7]

That does sound like cascading comboboxes. Review: http://www.datapigtechnologies.com/f...combobox2.html