You're going to have to write some code to do this. There is no simple
click-button-copy-paste-master-and-detail-records that I know of.Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186 Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10186
Your button would have to make a recordset for the top level data, add a
record, and then copy whatever fields you want in the new copy. Then, make
another recordset for the detail records and repeat the process for that
You can also accomplish the same thing using a database object and writing
SQL on the fly, then using EXECUTE on the database object instead of making
recordsets. I prefer recordsets, but it depends on several factors.
Which are you comfortable with?