To associate two tables and create a parent/child relationship:
I click the “Relationship” button from the toolbar.
Select the parent table and drag to the child table.
What I notice is the existing child’s foreign key field is automatically selected (good), but in addition it also creates the foreign key column as a primary key too (wrong). So what I end up with is the child table having the proper foreign key selected AND the same field is included as the primary key (wrong). I think Toad is incorrectly creating “Primary Foreign Keys”, or I need to know how to disable this.