Copy header and related records

[Louverril]

I have a three tier record displaying on screen in a main form, a subform and
the subform of the subform.
The records are:
Header - Main form
SubHeader – Subform – one to many
SubSubHeader - Subform of Subform – one to many

Each record has an autonumber field as the primary key and the second field
is the one which links it to its parent.

I want to add a button to the screen to make a copy of the full record that
can then be displayed and edited.

I have followed Allen Browns example here:
http://allenbrowne.com/ser-57.html to succesfullly add the header and the
subheader records, but I am going round in circles trying to figure out how
to add the subsubheader records. This is different because you have many
subheader records rather than just the one as with header.

Thanks Lou

 

[Tom van Stiphout]

On Fri, 14 Mar 2008 12:26:03 -0700, Louverril

I'm not thrilled about Allen's solution.
The general idea of such copy is:
Copy the toplevel record
Copy the child records for the toplevel record
Copy the grandchild records for the child records

With that in mind you should be able to create three append queries.

-Tom.