Create a field that looks up data from another table in Datasheet view

1. In Datasheet view, open the table where you want to add the lookup field.
   
   
2. To insert the Lookup field within the table, click in the column to the right of where you want to insert the field, and then on the Insert menu, click Lookup Column.
   
   
3. In the first dialog box of the Lookup Wizard, select the option that indicates you want the Lookup field to look up the values in a table or query.
   
   
4. Click Next and follow the directions in the remaining Lookup Wizard dialog boxes.

   When the Lookup Wizard is finished, the Lookup field is added to your datasheet. By default, the new Lookup field will be given a name in the datasheet, "Field#," where # is some number. You can change this name if you want. To find out how to change a field name in Datasheet view, click .

Notes

• When you use the Lookup Wizard to create a Lookup list, Microsoft Access sets certain field properties based on the choices you made in the wizard. Once you've created a Lookup list field, if you add the field to a form, Microsoft Access copies its definition into the form. The combo box or list box is created automatically for the form. However, if you change the definition of the field in the table after adding it to a form, those changes will not be reflected in that form. To correct this, delete the field from the form and then add it again. For information on the properties that the Lookup Wizard sets, click .
  
  
• It is also possible to add a Lookup field to a table that displays values from the same table that contains the Lookup field. For example, in the Employees table of the Northwind sample database, the ReportsTo field is a Lookup field that displays data from the FirstName and LastName fields by looking up the corresponding EmployeeID.