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
You can specify a join condition with the following entries:
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.