How to compare line items from different records
FM 11 Windows
Situation: Quoting database - Each quote record has 40-60 line items.
I want to be able to use the quoting database to create change orders. I would do this by taking two records and create another record in a Change order database that has the part number and difference in price and quantity between the two quote records.
What is the best way to set the data up to compare line items from two different records? (some sort of temporay storage?)