AnsweredAssumed Answered

How to copy sub summary results to a field in another table?

Question asked by MarlynMclennan on Sep 26, 2012
Latest reply on Sep 26, 2012 by philmodjunk

Title

How to copy sub summary results to a field in another table?

Post

      

     I have a summary report based on a LineItems table showing how many of each style have been ordered. 

     A found set is selected by invoice number.

      

     Also I have a WorkBook table with one record per style.

      

     Now I want to use these LineItems subtotals in further calculations.

     I want to copy these subtotals to a field in WorkBook. 

      

      

     Trying ReplaceFieldContents:

      

     From Workbook, sorted by StyleID, ReplaceFieldContents of field WorkBook::Needs

      

     If (StyleID = workbook_LINEITEMS::StyleID;

       GetSummary ( workbook_LINEITEMS::QTYtotal; StyleID );

      0)

      

     This doesn't work. I run a script to do the ReplaceFieldContents from WorkBook.

     The result is mostly blank but some 0 in random places, seeming unconnected to matching StyleIDs.

      

Screen_Shot.png

Outcomes