Forms4.5 help request

[Quoted] I need advice on implementing the following case:

[Quoted] 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.

I know that I could use the server to add the detail records on a commit trigger, but I don't want to do an intermediate commit during the processing of the form -- since the master could be rolled back.

Can anyone verify this approach or offer a better solution?

Thanks in advance...
  mburnham_at_globaldialog.com Received on Fri Jan 24 1997 - 00:00:00 CET