Foreign Key Reference

To setup a foreign key reference, open Admin > Foreign Key Reference .

CAUTION:

Important! If you introduce a new foreign key reference, carefully consider its naming convention. Refer to System Data Naming Convention for more information.

Description of Page

Enter an easily recognizable FK (foreign key) Reference code and Description for the table.

Enter the name of the Table whose primary key is referenced. After selecting a Table, the columns in the table's primary key are displayed adjacent to Table PK Sequence.

Use Navigation Option to define the page to which the user will be transferred when they press the go to button or hyperlink associated with the referenced entity. Refer to Navigation Information Is Dynamically Derived for more information on how this is used.

The Info Program Type indicates whether the default program that returns the standard information description is written in COBOL or Java.

If the Program Type is COBOL, use Info Program Name to enter the name of the COBOL program.
If the Program Type is Java, use Info Program Name to enter the Java class name.

Refer to Information Description Is Dynamically Derived for more information on the info program is used.

Note: COBOL Programs. COBOL programs are not supported by all products.

Note: View the source. If the program is shipped with the base package, you can use the adjacent button to display the source code of this program in the source viewer or Java docs viewer.

Use Context Menu Name to specify the context menu that appears to the left of the value.

Use Search Navigation Key to define the search page that will be opened when a user searches for valid values. This is only applicable for characteristics and column references.

Use Search Type to define the default set of search criteria used by the Search Navigation Key's search page.

Use Search Tooltip to define a label that describes the Search Navigation Key's search page.

Note: Context Menu Name, Search Type and Search Tooltip. These attributes are only applicable to user interface elements utilizing the foreign key compound element type. Report parameters that reference foreign key characteristics are an example.

Where Used

Follow this link to open the data dictionary where you can view the tables that reference CI_FK_REF.

Foreign Key Reference - Main