- 1). Open the table in "Design View" by right-clicking the title in the Navigation Pane and selecting "Design View." Create a new field by typing a title into a new row of the table design grid. Click on the data type drop-down box and select "Lookup Wizard..." to open the lookup wizard tool.
- 2). Select the first option to look up fields from another table. This function creates a relationship between your tables and uses the field data from the source field to populate the cell in your destination field. For example, if you have a "Students" table you can use your students' names in a field of your "Student Assignments" table.
- 3). Choose the source table or query and select which fields you want listed in your lookup field. Display the field in ascending or descending order and set the column width. Select the "Allow Multiple Values" to let the user make more than one choice per record.
- 4). Select the second option of the Lookup Wizard to type in your own field listings. Instead of using information from another table, this displays a limited number of field choices. If you want your "Student Grade" field to only display A, B, C, D or F, you can set those parameters in this option.
- 5). Save the table by pressing the save icon at the top right-hand corner of the screen. Switch to "Datasheet View" to review your changes and test your lookup field. Click on the "View" button on the ribbon at the top of the page and select "Datasheet View."
- Advertisement -
- Advertisement -