How To Change The Data Displayed In A Linked Field In An Access Table

If you link two tables in Access, for example a primary key in one table to a non primary key in another table, the linked field in the second table only shows primary field values from the first table. You can change what is displayed in the second table by using a lookup based on the primary key to show more meaningful data from the first table. Read this brief article to discover how to do this.

The full article appears here:
http://www.microsofttraining.net/article-1869-how-change-data-displayed-in-linked-field-in-access-table.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com