FK References
Select FK Reference from Admin Menu to navigate to the Foreign Key References Window. The Main tab of the FK References Window maintains the meta-data related to foreign key references on the FK References List.
FK Reference Property Editor
FK Reference Property Editor
The FK Reference Property Editor maintains the properties of a foreign key reference record and the metadata can be edited in this Window.
Properties Description
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 as a characteristic value. After selecting a Table, the columns in the table's primary key are displayed adjacent to Table PK Sequence.
The remaining fields control the behavior of the foreign key reference. See the description that appears above the page snapshot for more information about these fields.
Use Navigation Option to define the page to which the user will be transferred when they press the go to button that prefixes a characteristic value.
The Info Program Type indicates whether the program that returns the information displayed adjacent to a characteristic value is written in Java.
• If the Program Type is Java, use Info Program Name to enter the Java class name.
Use Context Menu Name to specify the context menu that appears to the left of the value.
Note:Context Menu Name. This attribute is only applicable to user interface elements utilizing the foreign key compound element type. Report parameters that reference foreign key characteristics are an example.
Use Search Navigation Key to define the search page that will be opened when a user searches for valid characteristic values.
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: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.