At 11:39 PM 15/02/2004 +0000, you wrote:

>--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> > At 02:26 PM 15/02/2004 +0000, you wrote:
> > >I am attempting a secondary update to a dataset in its AfterPost
> > >event.
> >
> > Why?
> >
> > Helen
>
>The dataset is a master (sales order) with two details (1=order
>items; 2=percentage commission payable to agents). When, for example,
>an additional item is added to the order, the order value (stored in
>the header) changes. The commission due to each agent then needs to
>be re-calculated, and the total reflected in the margin (=total sales
>value less total costs, less total commission) - these totals are
>also stored in the master.
>
>I detect a change to any of the totals in the BeforePost of the
>master, and hoped to use this to trigger a re-calclation of the
>others in the master's AfterPost.

So - are these calculated fields in the app? or are they computed or
run-time columns from the database?

It matters...if they are calculated (and not stored in the database) then
you shouldn't be trying to push them into the Post event at all (before or
after).

Helen

>