One form to add/update multiple table 1

[TheWebDataGuy]

I am new to the Access world, looking for some help.

I am trying to develop a form that adds/updates data in multiple tables. I can do it one table at a time but multiple tables from one form looks tricky to me.

Any suggestions??

Thanks.

 

[jebry]

Hi!

In most cases you would use one of two strategies. Create a query to get the fields you want on the form and base the form on the query(used mostly when the relationship between the tables is one-one). Second, when the relationship is one-many, base a form on the main table and put a subform on the main form for the second table.

hth Jeff Bridgham
bridgham@purdue.edu