Can 1 form update 2 tables? (1 Viewer)

[myrock]

My requirement is:

In the form, find a record in table A by SSN, display several fields on the form with data from table A. Have several other fields on the form that data is then keyed into. Add a new record to table B with all the fields from the form. Can this be done? Can there be more than 1 source for a screen. All ideas welcome. Thanks Tom

 

[Jack Cowley]

You use queries to combine data from more than one source. Depending on what you are doing here you may want to set up these two tables in a One to Many relationship. If that is the case then a form/subform approach would probaby be the best.