Form to create one record in one table, multiple in another

[ustinjay]

Hi there

I have two tables which are in a one-to-many relationship (the example I am dealing with is a mother and her children).

I want one form for the mother, with fields such as date of birth, and when you click Add Record I want the mother table to be updated with the new record.

However on this form I also want a field for "number of children" and when the Add Record button is clicked, not only does the table containing all the mothers get a record added, I would like XX records added to the children table where XX is the number of children entered into the form. These should have separate IDs but retain a common field that identifies the mother.

Thanks so much!

 

[Misiek]

I would create a form based on table mother and add a subform with this single field from table children. Then when you save, all records should update.

 

[JHB]

Use an update query and a loop.