Microsoft® Office Access™ 2007 Plain & Simple

Creating a Lookup Field

Many times the data you need to enter in one table can be found in another table. In the Northwind database, for example, if you add a new product, you must assign it to a category. Rather than make you open the Categories table separately and find the value you need, Access lets you display those values in a list. You can also create your own list, rather than drawing values from an existing source.

Define a Field as a Lookup Field

1. Open a table in Design view.

2. Click the field to define as a lookup field.

3. Click the Data Type ...