GLOBAL MAP DATA DICTIONARY #1.5219 -- SQLI_FOREIGN_KEY FILE 3/24/25 PAGE 1 STORED IN ^DMSQ("F", *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 22.2) ----------------------------------------------------------------------------------------------------------------------------------- A set of columns in a table that match the primary key of another table. They represent an explicit join of the two tables. Each foreign key element points to it's table element (SQLI_TABLE_ELEMENT), a column in the local table (SQLI_COLUMN) and a primary key element of a foreign table (SQLI_PRIMARY_KEY). The primary key table element of the foreign table has the domain of that table, which makes the connection. CROSS REFERENCED BY: F_TBL_ELEMENT(B) ^DMSQ("F",D0,0)= (#.01) F_TBL_ELEMENT [1P:1.5216] ^ (#1) F_PK_ELEMENT [2P:1.5218] ^ (#2) F_CLM_ELEMENT [3P:1.5217] ^ INPUT TEMPLATE(S): PRINT TEMPLATE(S): SORT TEMPLATE(S): FORM(S)/BLOCK(S):