Subject Re: IB_Query remains in EditMode after Posting
Author andygarneruk
--- 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.

Best regards, Andy.