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

Setting the Properties of Foreign-Key Items in the Detail Block

When you create a relation, Oracle Forms sets the Copy Value from Item property on the foreign-key items in the detail block automatically. The Copy Value from Item property specifies the name of the corresponding primary-key item in the format MASTER_BLOCK.ITEM_NAME. At runtime, the value stored in the primary-key item in the master block is copied to the foreign-key item in the detail block whenever a detail record is created or queried.

When you create the relation in the Data Block Wizard, Oracle Forms does the following to the foreign-key item(s) in the detail block:

Also, if the relation was created in the Data Block Wizard, Oracle Forms does not create a boilerplate text label for the foreign-key items.

When you create a relation in the Object Navigator, rather than in the Data Block Wizard, you might want to set these same properties yourself.

The purpose of these settings is to hide the foreign-key item(s) from the end user, since the same information is likely to be displayed in the primary-key item(s) in the detail block. These settings are most appropriate when end users can view both the master and detail blocks at the same time. If end users cannot see the master block when viewing detail records, you may want to undo these settings so that foreign-key item(s) are visible to the end user. If you do, be sure the Update Allowed item property is set to No (so end users cannot edit the foreign-key value, thereby disrupting master-detail coordination).