Re: F45 can't save detail record

Sean,

How about a Post-Insert trigger on the Master block, which selects the primary key value from the database? The master's Post-Insert will fire during commit before the detail block rows are inserted. In the detail block's Pre-Insert, copy the value. You will need to fetch into a nonbase table (or control) item to avoid problems.

Sean McMurray wrote in message <378A5D2B.F591FD63_at_xmission.com>...
>In a master-detail form, my master record receives it's primary key
>value from a BEFORE INSERT trigger on the server.
>Forms 4.5 is able to save the master record, but is unable to save a
>detail record, because the detail record never received the value of the
>master record's primary key. This value is also part of the primary key
>for the detail record.
>
>How can I obtain the primary key value after the master record is saved,
>but in time to use in saving the detail record?
>
Received on Fri Jul 16 1999 - 07:29:24 CEST