Info boxes may "borrow" one or
more columns from their parent, the so-called joined columns.
Typically, these columns are used to display non-key information
(especially if the key columns are not very meaningful to the end
user). It is also possible, however, to borrow key columns. (In
case of embedded (related) info boxes, the primary key columns of
the parent are already part of the child info box, but have been
set to non-displayed.)
Joined columns, whether inserted via the Windows Designer or
specified in the Definer, cannot be accessed via ODBC.
To insert a joined column:
||Use the Windows Designer catalog to open the appropriate
||In the design view, select the Info Window object that is the
child in the relationship.
||From the menu bar, choose Insert, Joined Columns.
||From the dialog that appears, choose the table, then the
relationship, and then the column(s) that you want to borrow.