I _think_ you need either: PROPERTY TABLE FormTableName REFRESH
or PROPERTY TABLE FormTableName CLOSE PROPERTY TABLE FormTableName OPEN placed before your current property statements where FormTableName is the table associated with your detail section. Regards, Alastair. ----- Original Message ----- From: Jim Belisle To: RBASE-L Mailing List Sent: Tuesday, November 18, 2008 10:27 PM Subject: [RBASE-L] - table info not updating 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 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.9.6/1797 - Release Date: 18/11/2008 11:23
