View Full Version : inserting lookup fields


Robear Dyer
06-01-2001, 10:48 AM
I'm creating a form based on two tables that are linked by an ID number. I'd like to be able to type in an ID number for table A, and see data from table B displayed for the corresponding ID number. Is there an easy way to do this?

Pat Hartman
06-01-2001, 10:53 AM
This question is posted several times each week. Search the archives for answers. You can also look at working examples in northwinds.mdb, solutions.mdb, and smpfrm97.mdb. If you don't have any of these sample databases installed, they can be downloaded from the Microsoft download site.
http://www.microsoft.com/downloads/search.asp?

Jack Cowley
06-01-2001, 10:54 AM
If both tables have a link to the ID then the ID exists in table B. Therefore you should be able to create a form based on table B and display the data that you want. Or you can create a Mainform/Subform form and have the data from table B displayed in the Subform when you select an ID in the main form...