Master-Detail Relation (Triggers/Procedures/Properties)

On-Check-Delete-Master: - Fires when Form Builder attempts to delete a record

in a block that is a master block in a master-detail relation.
On-Clear-Details: - Fires when Form Builder needs to clear records in a block that is a detail block in a master-detail relation because those records no longer correspond to the current record in the master block.
On-Populate-Details: - Fires when Form Builder needs to fetch records into a block that is the detail block in a master-detail relation so that detail records are synchronized with the current record in the master block.

(i)         Isolated: - Masters Can be deleted when Child is existing

Triggers: - On Populate details             Block

                  On Clear Details                 Form 

Procedure

                        Check Package Failure

                        Clear all master Detail

                        Query Master Detail              

(ii)        Non- Isolated: - Masters Cannot be deleted when Child is existing.

Triggers: - On Populate details            Block

                  On Check Delete master    Block            

                              On Clear Details               Form  

Procedure

                        Check Package Failure

                        Clear all master Detail

                        Query Master Detail              

(iii)       Cascading: - Child Record Automatically Deleted when Masters is deleted.

Triggers: - On Populate details             Block

                  Pre Delete                                       Block

   On Clear Details                 Form 

Procedure

                        Check Package Failure

                        Clear all master Detail

                        Query Master Detail