2 Replies Latest reply on Jan 5, 2011 9:49 AM by donjuancarlos_1

    How to compare line items from different records

    donjuancarlos_1

      Title

      How to compare line items from different records

      Post

      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?)