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


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?



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:


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