Comments
Sort by recent activity
Say I have a table participants with PK part_id and another table DeliveryAddress with foreign key part_id.
If i setup the foreign key on DeliveryAddress back to the participants table then it will only select unique part_id when a participant could have multiple delivery addresses.
There is a hint to the right of the "Population method" on the Foreign key generator UI stating: If the foreign key references a single column, each value in the referenced column is only used once. I have tested this and it creates a one to one foreign key. / comments
Say I have a table participants with PK part_id and another table DeliveryAddress with foreign key part_id.
If i setup the foreign key on DeliveryAddress back to the participants table then it will...