Mapped Secondary Table Setup

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.

  1. Select a secondary table from the combo box.
  2. 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.

  3. To set up a reference key, click the fields and select column from the combo boxes.
  4. 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."

    Tip 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.
  5. You can add and remove column pairs with the Add Pair and Remove buttons. Click OK to return to the Select Tables dialog box
See also
Mapping
Primary and Secondary Tables

Legal Notices