Hi Don. Here is one way you could do it.
1. Create an autocreate relationship between OrderLineItems and InvoiceLineItems TOs (table occurrences).
2. Create InvoiceLineItems fields as "Auto-enter Calculations" referencing the corresponding OrderLineItems fields.
3. On a layout with the OrderLineItems records set the InvoiceLineItems::OrderLineItems foreign key.
4. Put step 3 into a looped script to do the same thing for each record in the found set.
I've included a sample file that shows this method.
Hope this helps. Chris
Order to Invoice.zip 68.3 K