Change ID to something users can consume

[Aenon]

Greetings!

I am trying to create forms to interact with a database i made to track usage of assets. In my tables i have linked many of my assets to each other by using their unique ID numbers. For instance the ID number of my assets are linked to a foreign key in a locations table. This way i was hoping to be able to find out which assets that was at the different locations at a given time. However, a form based on the tblAssets will then only include the foreign key which is a number and incomprehensible to a user. How can i make the form change this foreign key to the location name linked to the ID in tblLocations?

 

[jzwp22]

How can i make the form change this foreign key to the location name linked to the ID in tblLocations?

If this form is going to be used for data entry/data editing, then it would be best to replace the control that holds the location foreign key with a combo box. The combo box wizard will step you through the process.

If the form is used strictly for viewing (no entry or editing) then you can use a query that joins the main table with the location table and include the location name in the query. Then it will be available for use on the form.