Autolookup Fields in Access

P

Patti Davignon

I am trying to create an autolookup field between two tables. I want to look
up records from my instructors database, on the form for by class database.
My plan is to be able to enter the name of the instructor and have the
address auto fill in the blanks. Can you help me?
 
D

DevalilaJohn

Put the details about the instructor in a subForm that links to the class
field based on the instructor. You may want to use a combo box type of look
up in your primary field where you can store an instructor number, but
display the name. This way you avoid the issues around "which professor John
Smith".
 
Top