How to copy sub summary results to a field in another table?
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.
From Workbook, sorted by StyleID, ReplaceFieldContents of field WorkBook::Needs
If (StyleID = workbook_LINEITEMS::StyleID;
GetSummary ( workbook_LINEITEMS::QTYtotal; StyleID );
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.