Article ID: 304463 - View products that this article applies to.
This article was previously published under Q304463
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 2002 version of this article, see 304462
In Microsoft Access, you can add a field to a table to look up information in another table. You typically use this technique when you want to create relationships between tables. For example, perhaps you have a Products table with a Category field that looks up the category name from a Categories table. By using this technique, you can store the primary key value only in the Categories table, but display the more useful Category name.
This article shows you how to add lookup fields to a Microsoft Access table. First, it shows you how to use a wizard to add the lookup field, and then it shows you how to add the lookup field manually.
Using a Wizard to Create a Lookup Field
Manually Creating a Lookup Field
For more information about creating lookup fields, click Microsoft Access Help on the Help menu, type lookup field in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
For additional information about creating lookup fields in Microsoft Access, click the "Creating and Designing Tables" topic on the Microsoft Access 2000 Help page at the following Microsoft Web site:
Microsoft Access 2000 Help
Article ID: 304463 - Last Review: August 9, 2004 - Revision: 2.1