How To Creating a Lookup Field in Access 2003
The Lookup Wizard helps you create a field that displays either of two kinds of lists during data entry: a Lookup list that displays values looked up from an existing table or query, or a Value list that displays a fixed set of values you enter when you create the field. Because values are limited to a predefined list, using Lookup fields helps you avoid data entry errors in situations where only a limited number of possible values are allowed. The lists are not limited to a single column. You can include additional columns that could include descriptive information for the various choices in the list. However, only a single column, called the bound column, contains the data that is extracted from the list and placed into the Lookup field.
Create a Field Based on a Lookup List
 |
Display the table in Design view, enter a new field, click the Data Type list arrow, and then click Lookup Wizard.
|
 |
Click the I Want The Lookup Column To Look Up The Values In A Table Or Query option, and then click Next.
|
 |
Select the table or query you want to use for the Lookup list, and then click Next.
|
 |
Select the fields that you want to appear in the Lookup list, and then click Next.
|
 |
Choose a sort order for the Lookup list, and then click Next.
|
 Resize the column widths in the Lookup list, indicate whether or not to include the primary key column, and then click Next.
If the table or query lacks a primary key, you will be prompted for the column that will act as the bound column. Otherwise the primary key will be the bound column.
 |
Enter a label for the Lookup column, and then click Finish.
|
Create a Field Based on a Value List
|
Display the table in Design view, enter a new field, click the Data Type list arrow, and then click Lookup Wizard.
|
|
Click the I Will Type In The Values That I Want option, and then click Next.
|
|
Specify the number of columns you want in the Value list.
|
|
Enter the values in the list. If necessary, resize the column widths. Click Next to continue.
|
|
Choose which column will act as the bound column, and then click Next.
|
|
Enter a label for the Lookup column.
|
|
Click Finish.
|
|
