Adding a Foreign Key Relationship to a composite table from a Primary Key table, adds all the foreign keys from the Primary Key table

Toad Data Modeler
1

Hi

I have a table with a primary key and other foreign keys. I then try to add the primary key from this table, as a foreign key to another table, which is also a composite table. The problem is that all foreign keys from the primary table get inserted into the secondary table and I cannot remove them. Is this a bug or am I doing something wrong?

Vik

2

Hi,

double click the relationship line to open Relationship Properties. On tab General, in groupbox Relationship Type, select the existing attribute in the grid in column Child:

rel-child.png

This way you can map attribute from parent table with existing attribute in child table.

Regards,

Vaclav