Access 2010 In Pictures
Employ the Lookup Wizard

What does the Lookup Wizard do?

The Lookup Wizard allows you to create a field where database users can choose from a list of things.

This list can come from a table or query, or list items can be specified manually.

1 In the Field Name column, type:


then press Tab.

2 In the Data Type column, click the down arrow, then Lookup Wizard...