How to transfer records between tables

Discussion created by rudydimaggio on Dec 1, 2016
Latest reply on Dec 2, 2016 by philmodjunk



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