Master-Detail Relationship in Oracle forms Blocks

Master-Detail Relationship in Oracle forms Blocks

First create Master data Block , then detail data block.

From HR schema  : Master Data Block is Departments
                           and Detail Data Block is Employees.

Layout Style 'Form' for Departments Block, with 1 record displayed.

Layout Style 'Tabular' for Employees Block, with 5 record displayed.

Setting Relations: ( During Layout Wizard) 

( At runtime the window will look like the above )

By Default in the Relation - Delete Record Behaviour property is Non-Isolated.

And likely below ON-POPULATE-DETAILS and ON-CHECK-DELETE-MASTER 
triggers gets automatically generated under the master data block.

If we change the Delete Record Behaviour property , the triggers will automatically change 
accordingly.

1. Non-Isolated :( Triggers are automatically generated under the master data block)
a) ON-POPULATE-DETAILS
b) ON-CHECK-DELETE-MASTER

2. Cascading :( Triggers are automatically generated under the master data block)
a) ON-POPULATE-DETAILS
b) PRE-DELETE 

3. Isolated :( Triggers are automatically generated under the master data block)
a) ON-POPULATE-DETAILS


What does the above three properties mean basically ?

Non-Isolated : Prevents deletion of master record if detail record is present.
Cascading : Deletes the detail record once master record is deleted.
Isolated : Only deletes the master record.

Challa.