User interface for relational database: basic feature
===

This is a bit embarrassing but it's been a while.

When working with relational databases and linking to separate tables by primary:foreign keys, in 1-∞, such that, in a particular table, the table's foreign relationship returns an integer ID... how do you go about making this relationship intelligible to users?

For example:

You have a **company** table

 - CID
 - CompanyName
 - CompanyLocation
 - CompanyBusinessType

etc (not actual column names)

and an **employee** table

 - EID
 - firstName
 - surName
 - DOB
 - email
 - company

Employee *company* is related to CID. But some user putting in information about an employee would have to know the ID code for the particular company due to the nature of the relationship. You can run a query to return 'CompanyName's along with their associated 'CID's which can then be searched, but this cipher is hardly an ideal solution. I just cannot remember the theory of how one approaches this, even though I'm certain I've done it before. I need to implement it in both Microsoft Access 2010 and Microsoft SSMS (separate databases fwiw); but the execution should be relatively straightforward as soon as I remember how it's done!
