If you create a new relationship between the two entities, a new foreign key will be created automatically.
You can set Automatic FK Mapping in Settings | Options | Model | Physical Model.
Following options:
- Disable - FK mapping is OFF
- Enable - TDM searches for matching attributes. If a single possible mapping option is found, the FK is mapped. If multiple possible mapping options are found, a dialog appears where you choose the attribute the FK should be mapped to.
- Always Show Dialog - Displays a dialog whenever there is one or more possible mapping options. You get to choose the attribute the FK should be mapped to.
You can use manual mapping (FK Mapping):
- Double-click the new relationship to edit it
- Click the attribute item in the Child column to expand the combo-box with other attributes of the child entity and confirm OK
Help for FK mapping is available online:
https://support.quest.com/technical-documents/toad-data-modeler/7.2/user-guide/21#TOPIC-1438185