I have a table: ORDERS related to ORDER_LINES which contains the details of the order.
And a table INVOICE related to INVOICE_LINES which contains the details of the invoice.
Now, when an order becomes an Invoice, I need to transfer all or part of the lines from ORDER_LINES to INVOICE_LINES
But I am not able to find an easy way to do that, any suggestion?
Filemaker 15 advanced on MacBookPro