Relationship Mapping Editor: Join to Foreign Key

In this panel, you relate a second bean to the join table you chose in the previous panel.

The editor will attempt to determine the most logical key column pairs between the join table and the table that the Related Bean is mapped to.

If the tables have a foreign key between them, the editor will use the foreign key as the default key column pair. If there is no foreign key, then you must create a key by choosing a pair of columns that will allow navigation from the join table to the table to which the Related Bean is mapped. The columns in each pair are expected to have the same value.

To create a compound key, use Add Pair to add additional key column pairs.

If the Finish button is disabled, you need to choose a join table and a key column pair.

See also

Mapping
Primary and Secondary Tables
Selecting a Secondary Table
Mapping Fields to Multiple Columns
Relationship Mapping Editor
Relationship Mapping Editor: Map to Key
Relationship Mapping Editor: Local to Join

 


Legal Notices