Copy Value from Item Property
Description
Specifies the source of the value that Oracle Forms uses to populate the item. When you define a master-detail relation, Oracle Forms sets this property automatically on the foreign key item(s) in the detail block. In such cases, the Copy Value from Item property names the primary key item in the master block whose value gets copied to the foreign key item in the detail block whenever a detail record is created or queried.
Applies to all items except buttons, chart items, and image items
Set Oracle Forms
Refer to Built-in
GET_ITEM_PROPERTY
Required/Optional optional
Usage Notes
- Specify this property in the form <block_name>.<block_item_name>.
- Setting the Copy Value from Item property does not affect record status
at runtime, because the copying occurs during default record processing.
- To prevent operators from de-enforcing the foreign key relationship, set
the Enabled property to No for the foreign key items.
- To get the Copy Value from Item property programmatically with GET_ITEM_PROPERTY,
use the constant ENFORCE_KEY.
Related topic
About the Copy Value from
Item property