Update automatically with linked forms

manwen

New member
Local time
Today, 21:07
Joined
Aug 2, 2002
Messages
6
I have two forms for two tables in a one-to-many relationship.. What I want to do is to be able to fill out the form in the many table (which has the primary key of the "one" table) and have it create a record automatically in the "one" table. So as it stands now, Access states that other data is required to be entered into the 'one' table before saving the entry in the many table. I guess I could just open the other form, but I would like to avoid creating so many steps.
 
Why not use a form with a subform? The main form shows data from the 1-side table and the subform shows data from the many-side table.
 

Users who are viewing this thread

Back
Top Bottom