DBGrid detail table Calc Field Totals in a master table

Rod

Delphi Developer

Thu, 19 Dec 2002 03:00:00 GMT

DBGrid detail table Calc Field Totals in a master table

I want to place the totals of a DBGrid Column (detail table) into a
DBEditField in the Master and then use this total to produce Calc field in
the DBgrid detail table.

Trouble is that ;
TdataModule2.Table2CalcFields(DataSet: TdataSet)
is executing before
TForm3.DBEdit1Change(Sender: TObject)

Hence the calculation on the calc fields in the DBGrid is incorrect. ie
using the Total from the previous Master.

Other Threads

1. Locate in Master/Detail tables causes Detail table to fail

2. Detail table key field updates on a Master/Detail relation

3. Calc Fields in Master-Detail

4. Master-Detail with Calc Field and Record Insert

5. dbgrids with master-detail tables

6. Adding record in detail table or create a new master table for it

7. PARADOX SQL - Update master-table from Detail-table

8. DBase Tables and Master detail on multiple fields

9. Calculated field with Master/Detail tables???

10. problem with lookup field in master/detail table