From the course: Access Quick Tips

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Building lookup tables

Building lookup tables - Microsoft Access Tutorial

From the course: Access Quick Tips

Start my 1-month free trial Buy for my team

Building lookup tables

“

- [Instructor] The class list table is a great source for the instructor classes field in the instructor's table. All I have to to is change the instructor classes field from a short text field to a lookup field using the lookup wizard data type. Through the wizard, I'll cite the class list table as the lookup source. I'll check Allow Multiple Values, leave the field name intact, and click finish. Save the table and then test it. I'm switching over to Datasheet View and now when I go to the instructor classes field I can click and check off the items that this individual teacher teaches.

Contents