Re: Forms4.5 help request

"Michael Burnham" <mburnham_at_globaldialog.com> wrote:
>I need advice on implementing the following case:
>
>I have a master-detail form. When a master record is created, I need to
>create a set of detail records automatically. (The detail records gather
>user-defined information about the master record. The users define the
>list of records that are tagged to each master elsewhere in the
>application.) There is a table that holds the "templates" of the detail
>records that need to be dynamically created when the master record is
>created.
>
>I have tried the following approach: I am using a trigger (tied to a
>validate action) on the master record that issues an "insert into the
>[detail_table] select [whatever] from [detail_template_records] where...".
>I then go_block to the detail block and query the records that were added
>behind the scenes. However, since forms didn't directly alter the records,
>I need to trick it into wanting to commit the records.
>

Hi there,

When you create an master record, navigate to the detail block and perform an execute query. Your detail block should issue an dynamic query (ie when invoked from master record craeation, it should query your template table to default all the records in the detail block). If it a normal query option from master block, it should retrieve your detail records.

It can be acheived by using dynamic where condition in forms 4.5. If you are using forms 3.0, then use UNION in the detail block,

Regards

N.Prabhakar Received on Sat Jan 25 1997 - 00:00:00 CET