Data in two tables, but need info on one form

[Kindi]

When you wish to edit information on a form about a certain record i am currently using a combo box which holds the names of the records, when one is selected the record appears in the form to be updated. How can the form bring information from the two tables to be edited with the same primary key, would that form need to be created based on a query?

Thanks
Kindi

 

[Rohdem]

Yes, you can make a query that contains all the information you want to show up on the form. You need to have a join in your query that links the two tables with the primary key.

You could also have a subform that is based on the second table and is linked to the main form through the primary key. Mike Rohde
rohdem@marshallengines.com