Propogating Key value to detail records
From: Sean McMurray <smcmurr_at_admin.dce.utah.edu>
Date: Thu, 01 Jul 1999 17:10:41 -0700
Message-ID: <377C0380.22F55E34_at_admin.dce.utah.edu>
I have a form with a master and a detail block.
Date: Thu, 01 Jul 1999 17:10:41 -0700
Message-ID: <377C0380.22F55E34_at_admin.dce.utah.edu>
I have a form with a master and a detail block.
The primary key for the master table is generated in a BEFORE INSERT trigger on the server, and is not displayed in the form.
When I add information into both the master and detail blocks of a new record and press save, Forms saves the master record, but is unable to save the detail record correctly. This is because the detail record doesn't know the value of the master record's key column.
How can I retrieve the key value after the master record has been inserted, but in time to use in inserting the detail record? Received on Fri Jul 02 1999 - 02:10:41 CEST