How to duplicate records on a form
Posted on 2011-05-03
I have an access form which is essentially an invoice (just like the ones you receive from your vendor, it has Customer name/address/ph#, order date, order amount, invoice date .. etc on parent table/ InvoiceMain table along with actual items (you bought) like item number, price, qty, ext cost ... etc on a child table/InvoiceItem table).
I know that I can append a invoice record from InvoiceMain and invoice item records from InvoiceItem table into the temporary tables and append them back to InvoiceMain/InvoiceItem tables using queires.
But I am wondering if there is a simpler way of duplicating an existing invoice information - like a built-in function or something like that.
I would appreciate your insight in advance.