Duplicating record in form and subforms

[achammar]

Hello!
So I have a form with subforms. The main form has it's own table, and each subform has it's own table. The main table has a 1 to many relationship with each subform table, so each record in the main table can show multiple records in each subform. What is the easiest way to automate (like clicking a button) so that a new record from the main table is duplicated, along with all the matching records of each sub table? The primary key in the main table is not auto number... I enter the value I want in case that makes a difference. The sub tables do not have a primary key, just the "many" field that is related to the main table. So my end result will be if I'm looking at a record in the main form, I click a button, and that entire record of the main form and subforms are duplicated exactly but with a different ID that I will enter.


Please keep in mind that I'm still learning so might not know any advanced explanations very well.

Thank you!

Albert

[ranman256]

2 append queries:
Q1 copies the master table to the target using the master ID

Q2 copies the sub table to the target using the master ID

[achammar]

Thank you ranman256!

That's the route I will start with then!

[ssanfu]

See if this tip by Allen Browne helps you.