Adjust column widths
A key column is the column that connects one table or query to another table or query. For example, you can use the Department ID field in the Employees table and the Department ID field in the Departments table to connect the two tables. You may, however, want to display the name of the department when you view the table but not the department ID; if so, leave the Hide Key Column box checked the connect the two tables. You may, however, want to display the name of the department when you view the table but not the department ID; if so, leave the Hide Key Column box checked.
1. Deselect Hide Key Column, if you wish.
2. Adjust the column widths by dragging or double-clicking the right vertical border for the column.
3. Click Next. The Lookup Wizard moves to the next page.
Specify the Key Field (if you deselected Hide Key Column)
A key field is a field that uniquely identifies a record. If you deselected Hide Key column, you must tell Access which field is the key field.
1. Click the key field.
2. Click Next. The Lookup Wizard moves to the next page.
Name the column
Field names appear at the top of each column. On this page of the Wizard you tell Access what you want to name your lookup column. In Access 2007, multiple values can appear in a field; click the Allow Multiple Values checkbox if you want to allow multiple values.
2. Click if you want to allow multiple values in the field.
3. Click Finish. Access creates the lookup column.
Post a Comment