Create a Lookup Column
If a field can contain a finite list of values, you can create a Lookup Column and users can select the value they want from a list. For example, if the employees at a school can only work in one of the following departments: Administration, Computer Science, English, History, or Math. You can create a table Departments table that lists the departments and then use the list in the Employee table to assign each employee to a department.
Departments | |
Department ID | Department |
Primary Key | |
1 | Administration |
2 | Computer Science |
3 | English |
4 | History |
5 | Math |
Access has a wizard to help you create lookup columns. Creating a Lookup column creates a relationship between two tables. See the section Create Relationships in Lesson 3 to learn more about relationships.
To use the Lookup Wizard to create a lookup column:
1. Open the table to which you want to add a lookup column.
2. Click the field label for the field before which you want to add a lookup column.
3. Activate the Datasheet tab. (You must be in Datasheet view.)
4. Click the Lookup Column button in the Fields & Columns group. The Lookup Wizard appears.
5. Make sure the radio button next to “I want the lookup column to look up the values in a table or query.” is selected.
6. Click Next. The Lookup Wizard moves to the next page.
Open the Lookup Wizard
0 comments:
Post a Comment
Enter your comments to JoxTech