I have the below EEP in a field for a form. Everything works except for the QuoteTotalAmount. I have checked to make sure the component ID is spelled right. If I go from the detail section where this EEP is located to the Header section and then back to the detail section, it updates. This is based on two temporary tables.
RECALC VARIABLES SELECT (SUM(ItemExtPrice)), (SUM(ModelExtWgt)) INTO + vSubTotal INDIC ivSubTotal, + vTotalWeight INDIC ivTotalWeight + FROM tQuoteDetail WHERE QuoteID = .vQuoteID SET VAR vSurcharge = (.vSubTotal*0.065) SET VAR vFreightAmount = QuoteFreightAmount IN tQuoteHeader WHERE QuoteID = + .vQuoteID SET VAR vTotalAmount = (.vSubTotal + .vFreightAmount + .vSurcharge) PROPERTY QuoteTotalWeight TEXTVALUE .vTotalWeight PROPERTY QuoteSubTotal TEXTVALUE .vSubTotal PROPERTY QuoteSurcharge TEXTVALUE .vSurcharge PROPERTY QuoteTotalAmount TEXTVALUE .vTotalAmount RECALC VARIABLES RETURN Jim
