Virtually Join Data Tables
The Link ID column property marks a column in the auxiliary data table as the ID column. That is, the rows of the data table are uniquely identified by the values of the ID column. The data table that has a Link ID column property is referred to as the referenced data table.
The Link Reference column property links a column in the main data table to the Link ID column in the referenced data table. The column property specifies the path name of the referenced data table. The column that has a link reference is referred to as the referencing column. The referencing column can look up the data of the auxiliary data tables through the Link ID column.
Figure 5.36 shows an example of virtually joined data tables. Pizza Profiles.jmp is the referenced data table because the ID column contains a Link ID column property. The ID column contains unique values that correspond to data in the referencing data table, Pizza Responses.jmp.
Figure 5.36 Virtually Joined Data Tables

Help created on 10/11/2018