Things You'll Need:
-
Step 1
Open your table in Design view.
-
Step 2
Insert a new row in the spot where you want your new field to appear. If you want to put the new field at the end, click in the first empty row.
-
Step 3
Name your field.
-
Step 4
Click in the datatype box immediately to the right. A small arrow appears in the right corner.
-
Step 5
Click in the small arrow to view a menu of choices. Select Lookup Wizard.
-
Step 6
When the wizard appears, select "I want the Lookup Column to look up values in a table or query."
-
Step 7
Follow the wizard's instructions. Click Finish when satisfied.
-
Step 8
Save your table. When you look at your table in Datasheet view, clicking on the empty field will provide a menu of choices based on the field values that you "looked up."
-
Step 1
Open your table in Datasheet view.
-
Step 2
Create a new column where you want your new lookup field to appear.
-
Step 3
Name your new field.
-
Step 4
From the Insert menu, select Lookup Column.
-
Step 5
When the wizard appears, follow the same procedures mentioned above.
-
Step 6
Save your table.







