Linking Fields

[creation303]

How do I link two fields together on a form, not a subform to master form? Or if I enter supervisor ID in one field...how to automatically enter supervisor name in the supervisor field?

 

[traingamer]

Use a combo box.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[creation303]

Yes...that was helpful. Any idea on how to take away duplicates in a combo box?

 

[PHV]

Use the DISTINCT predicate in the SQL code of the RowSource:
SELECT DISTINCT supervisorID , supervisorName ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[creation303]

Yes, that was it!