Toad World® Forums

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

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

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