Nested datasets, Aggregates and calculated fields

BDS2006

MSSQL 2000

Hi all

I do have a very special problem:

I have a pair of clientdatasets which works in Master-Detail relation
(Master cds through dataset provider to a ADODataset, and Detail cds as a
nested dataset (DatasetField etc))

Works fine.

The Detail cds has some aggregate fields (Average and count)
In the Master cds, I want to have calculated fields that reflect the
aggregate field values from the Detail cds.
Apparently, the "OnCalcField" in the Master cds is fired BEFORE the detail
cds calculates the aggregate fields, and therefore, the values I get in the
calculated fields reflects the values from PREVIOUS record cursor, and not
the CURRENT, meaning that the values comes too late.

- or are there any other means to get the aggregate fields in a detail cds
as a field in the Master cds?

Best regards

Anders


.