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

Join Condition Property

Description

Defines the relationship that links a record in the detail block with a record in the master block.

Applies to relation

Set Oracle Forms

Required/Optional required for a relation object

Usage Notes

You can specify a join condition with the following entries:

Join Condition Restrictions

Join Condition Examples

Examples:

To link a detail block to its master block through the ORDID text item that is common to both blocks, define the following join condition:

ORDID

To link the detail block to its master block through a number of text items, define the join condition as follows:

:block1.item1 = :block2.item1 AND :block1.item2 = :block2.item2

Keep in mind that the join condition specifies the relationship between the items in each block, not between the columns in the tables on which those blocks are based. Thus, the items specified must actually exist in the form for the join condition to be valid.