Hello,

I need to calculate totals for a master-child-grandchild relationship. The total value in the
master table is the total of values for the child table and the values in the child table are the
total values for the grandchild table.

Can anyone tell me the best/safest way of doing this without getting circular.

Warren

If the sum is only a calcualted field, then in addition to the OnAfterPost event
for the detail, I'd do the sum from the master datasource's  OnDataChange event...

The sum could be done either by:

1. instantiating a TTable and scaning  through that TTable's records to do the sum

2.  Using a TQuery and SQL to get the sum ie:

SELECT Sum(ExtdCost)
WHERE OrderNo = 1234

===
Bill

An addition to what Bill has already told you.  Be very careful of the fact
that a master table's OnCalcFields event fires _before_ the link to the
detail table is updated. Therefore, if you try to create a calculated field
for the master that scans the detail to sum a value you must use a second
TTable and call SetRange to see the correct set of detail records.

--
Bill

In article <6degis$ft...@forums.borland.com>,
        "Bill Todd (TeamB)" <bill_todd.nos...@compuserv.com> wrote:

Warren.

Try scanning a second TTable object to compute the totals.

--
Bill

(TeamB cannot answer questions received via email.)
(To contact me for any other reason remove nospam from my address)