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. |
Specifying the join condition for a master-detail relation