I have 2 tables set up in a master/detail relationship.
I need a total for the detail table and I need it to be seen by a data-aware
component. (A total for each master record)
So I created a calculated field for the MasterTable.
This works except I also need to update the Totals field without touching
the MasterTable and so the OnCalcFields event does not occur.
How do I force the MasterTable to do a reCalc?
I have tried "MasterTable->Refresh()" but this cycles through all master
records. I have tried "MasterTable->Edit(); MasterTable->Cancel()" to get
the OnCalcFields event to occur. Edit() works well, but Cancel() cycles
through all records.
Howard