Online Documentation for SQL Manager for MySQL
Binding master and detail levels
Define pairs of fields to link the Master Level and the Detail Level data sources:
- select a field in the Master Level Key Fields list;
- select a corresponding field in the Detail Level Key Fields list;
- click Add to set correspondence between the selected fields.
The newly created correspondences are listed in the Links Between Master and Detail Levels area. If necessary, you can delete any correspondence using the Remove button.
The From Foreign Key... menu is available if the Show tables related by foreign keys only option has been selected at the previous step. This menu allows you to select the foreign key to be used for identifying master-detail levels (if the table has more than one foreign key relation).