Editing records in 2 tables, but 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

 

[ghubbell]

Hi Kindi,
Yes that is one of many ways. Design a query (you can even use a wizard to do this for you) and choose from more than 1 table, joined by the key field(s). While the query is in query view, see if in fact you are able to add or edit the field(s) that you want. If this is sucessful, have the "form wizard" whip you up a new form that is based on your new query. Give it a try, as it only takes a few seconds with a wizard. If you don't like something, delete it and try again! Gord
ghubbell@total.net