ACC2000: How to Add Lookup Fields in a Microsoft Access Table (304463)
The information in 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.
SUMMARY
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.
REFERENCESFor 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:
Modification Type: | Minor | Last Reviewed: | 8/9/2004 |
---|
Keywords: | kbdownload kbhowto KB304463 |
---|
|