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

New Relation

Creates a new relation based on the displayed Master Block.

Detail Block

Enter the name of a block to be related to the master block, or click Select for a list of available blocks from which to choose. The Detail block must already exist before you can create a new relation to it.

Master Deletes

Determines what occurs when a record in the master block is deleted. Set one of the following:

Cascading: Allows master record to be deleted and automatically deletes associated detail records upon commit. Only records in the immediate detail block are deleted.

Isolated: Allows master record to be deleted, but does not effect the associated detail records.

Non-isolated: Prevents the master record from being deleted if there are associated detail records.

Coordination

Deferred: Detail records are not automatically fetched. The user must navigate to the detail block and explicitly execute a query.

Auto-Query: Detail records are fetched when the user navigates to the associated detail block. Part of the Deferred setting.

Prevent Masterless Operation: Prevents inserting or querying records in the detail block when there is no associated master record.

Join Condition

Enter a valid join condition in the multi-line field. The join condition defines the relationship between the master block specified in the Master text box and the detail block specified in the Detail text box. See Specifying the join condition for a master-detail relation.

Example: warehouse.region_id = region.id

Object REF Specifies a join condition based on an object which exists on both the master block and the detail block. Select an object from the drop-down box.

 


About the join condition

Specifying the join condition for a master-detail relation

Setting relation properties that affect coordination

Choosing the appropriate coordination