Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ComboBox Three Card Monty
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00323878
Message ID:
00323898
Views:
28
Barbara,
Thank you for your time.

Yes, the correct name is only in one record.
You could look at as, one name in four languages. The problem is you don't know which language you will find it. Hence, three card monty:). That is why I want to populate each combo with distinct. If I use fields as the RowSource I have blank fields to search through.
The key here, once the name is selected the other three need to be seen in order to compare and update the documentation.

Peter

>If you're only looking for one name, why use 4 combos? You can use the JOIN command (or a series of SQLs) to get a single cursor with a distinct list of all the names in all 4 fields. Or will you need to find "Berkeley" in combo1 sometimes but "Berkeley" in comb2 other times? In other words is any given name found only in one record, one PK at a time?
>
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform