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

About Master-Detail Relations

A master-detail relation is an association between two data blocks—a master block and a detail block. The relation reflects one of the following:

Consider an inventory-control application for a worldwide sporting goods distributor. There is a REGION table for geographic regions, and WAREHOUSE tables for goods warehouses in the various regions.

The application includes data blocks based on each of these tables. Since each warehouse is in a specific region, there is a primary-key to foreign-key relationship between the REGION and WAREHOUSE tables. This relationship also defines a master-detail relation between the blocks: the REGION block is the master block, while the WAREHOUSE block is the detail block.

The master-detail relation automatically does the following:

For example, when the end user changes the current record in the master block by navigating to a different region record, Oracle Forms updates the detail block to display only the records for warehouses that are within the selected region. Similarly, when the end user queries a particular region in the master block, you can have Oracle Forms automatically retrieve the records for all of the warehouses in that region.


About the join condition

About block coordination

About the Copy Value from Item property

About the Relation object

About creating a master-detail relation