Relating ID codes to something meaningful

[clobug1]

When adding a new candidate and their personal details to my database I use a form for data entry. It is necessary to store the workplace at which they are based so I have a relationship between the tables, workplace:candidate, 1:many as obviously many people may work at one workplace. Presumably it is best to store the workplace_ID in my CANDIDATE table?!

As the workplace_ID is a meaningless autonumber is it possible to select the workplace_name on my form but store the workplace_ID in my table? If so, how do I do it and is it going to involve something complicated (not au fait with VBA yet)?

 

[llkhoutx]

Candidate table:
CandidateID
sCandidateName
WorkPlaceID
etc.

Workplace table:
WorkplaceID
SWorkplaceDescription

On your form use a two column combo box to select the associated Workplace, column 0 (bound column) is workplaceId with width 0, column 1 is aWorkplaceDescription with width 1 (or whatever you want to diosplay). The combob box is bound to Candidate table field WorkPlaceID.

 

[clobug1]

So simple and yet so effective! It works, thans v. much for your help.