I have four combo dropdown list boxes, each represents a field in the same table. I would like to populate each with the equivalent of a select distinct statement. When the user selects anyone of the four, the remaining three need to point to that same row. They need incremental search and one must have column count = 2, to grab the PK.

Would someone please point me in the right direction? Should I use RowSourceType Array or SQL Statement and in which Method should I change the RowSource? Or do I need to get back in the ball park?

TIA

Peter In-Albon