A script-enabled browser is required for this page to function properly.

Creating a Master-Detail Relation in the Object Navigator

To create a master-detail relation in the Object Navigator:

  1. In the Object Navigator, locate the block that you want to be the master block in the relation, and (if necessary) click the + to display the Triggers, Items, and Relations nodes related to the master block.
  2. Select the Relations node under the master block, and choose Edit | Create.
    Oracle Forms displays the New Relation dialog, with the name of the master block you selected displayed in the Master Block field.
  3. In the Detail Block field, enter the name of the detail block, or click Select... and select a block from the LOV.
  4. Select settings for the Master Deletes, Coordination,and Join Condition behaviors then click OK.

Delete Record Behavior property

About block coordination

Prevent Masterless Operations property

Specifying the join condition for a master-detail relation

Setting relation properties that affect coordination

Choosing the appropriate coordination