Lookup lists are useful for fields that reference a specific list of items. Using a lookup field limits data entry to items in the lookup list. Data entry operators don't have to remember what the items are the data choices are presented as a drop-down list. The lookup list can reference another table or query in your database, or it can list items that you enter through the Lookup Wizard.
To use the Lookup Wizard:
Usually, a lookup list will only have one column; however, multiple columns are useful when fields are related (such as part and sub-part numbers). |
|
Notice that after using the Lookup Wizard, the data type for the field changes to number. |
|
You can also add a lookup column to a table in Datasheet view. You can only use this method to add a new column to the datasheet. To modify an existing field to use a Lookup list, use the Design view method.
|