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 ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.