A secondary table enables you to map your field directly to columns that are not part of your primary table. You can use this pane to select secondary tables, and to create compound keys by adding column pairs.
Once you select a secondary table, the tool checks to see if there is a foreign key between the primary and secondary tables. If so, the foreign key is displayed as the default reference key. If there is no foreign key, the editor displays "Choose Column," and you must set up a reference key.
Once you pick a primary column, the choices in the secondary column are limited to columns of compatible types. If no column is compatible, the field displays "No Compatible Columns." If you select a primary column that is incompatible with your secondary column, the value of the secondary column reverts to "Choose Column."
![]() |
If no pair of columns seems to relate in a logical manner, there can be no logical reference key. You may want to reconsider your choice of a secondary table. |
See also | |
---|---|
Mapping Primary and Secondary Tables |