Totals with Oracle Forms

I have a form with 3 data blocks (A, B, C) joined in 2 master-child relationships in a way that A is the master of B, B is the master of C.

I have special procedure to calculate the totals based on fields belonging to the C child table. When the user saves the changes I must update the result in a field belonging to the A master data block and the result must also be shown on the form.

The 3 data blocks are database tables and the fields that are involved are database items.

Which triggers can be used to execute the "Total Calculation and Update" code, and at which level? at the Form level, at A Data Block Level, B Data Block or C Data Block?

Please note that I couldn't find an easy way to use the built-in "Calculation" Properties supplied by Oracle Forms to do the job because I have 2 relations and not 1.

Thank you
Elie, Received on Fri Nov 05 2004 - 11:35:29 CET