Adding a Lookup Field to a Table Using the Lookup Wizard

To use the Lookup Wizard:

1. Click the field that you want to modify.
2. Click the Data Type drop-down arrow and click Lookup Wizard...
3. Select where your lookup column values will come from.
4. Click Next.
5. Click the name of the table or query you want to use.
6. Click Next.
7. Add the field or fields that contain the data you want displayed in your lookup column.
8. Click Next.
9. Adjust the width of your columns.
10. Click Next.
11. Enter a label for your lookup column.
12. Click Finish.
13. Save the table.
14. Click the View button on the toolbar to switch to Datasheet view.
15. Click the drop-down arrow to view your lookup column.

Click the field you want to modify, then click the Data Type drop-down arrow, and select Lookup Wizard... Decide whether your lookup list values will come from another table or query or if you will enter the list yourself. If the list will reference another table or query, select the table or query you want to use; then click Next and select the specific field or fields that contain the data for your list. Continue through the wizard, clicking Next to accept the default sort order and column width. Give the lookup list a name or accept the suggestion, and click the Finish button. Switch views to test your change.