Hi.
I previously had 3 separate fields on a form: school, contract name, and program name.
To save data entry folks time I made a combo box that shows all 3 fields, and when the user clicks on the appropriate combination, a field gets all 3 pieces of info and it is saved. (gov't requirement that this is saved in file that can be sent them, anytime).

ANYWAY, one mgr wants to run queries which will not only show the clients in a given contract, but only show the contract name and not the 1st or 3rd field that is saved.

HOW TO DO THIS? I can do the query to pick the proper contract with a "'like *w2000*" criteria, but how to SHOW only the contract name and not the otheerw ords?

Thanks.

IF too confusing let me know and I will try re-wording it.

Russ

Do you still have three separate fields?

You should NEVER store multiple attributes in the same field. Go back to your original approach with three combos.