rudydimaggio

How to transfer records between tables

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

Hi,

 

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?

 

TIA

 

 

 

 

Filemaker 15 advanced on MacBookPro

Outcomes