how to copy a mother-child record in vba?

K

keesb

I have a tabel [Invoice] and a table [InvoiceDet]. For every record in
[Invoice] their can be more records in [InvoiceDet].

So those are mother and child records.

The tables are joind by [Invoice_ID] (unic) and [InvoiceDetInvoice_ID].

Now I want to copy a record form [Invoice] into [Invoice] so making a
duplicate.
But at the same time the child records shout be copied also from and into
[InvoiceDet]. And after that connected by theire new [Invoice_ID] <>
[InvoiceDetInvoice_ID]

How can I do so in VBA ?

regards Kees
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Adding detail to record in a table in a secondary table 1
How to auto-post editable lookups? 2
VBA works in orignal but fails in copy of database 1
Assign Alpha Code to Child Record 2
Button to duplicate current forms (for an invoice) 1
Seeking suggestion for handling parent/child situation on continous forms 6
Need Help with a VBA subroutine 0

Top