2
Vote

Multiple relationships from one column

description

Hi,
It doesn't seem possible to create multiple relationships from a column on a table as when you try to create the second relationship the first is removed.
For example if I had the tables Address, PurchaseOrder and Invoice and wanted to create a relationship from Address.AddressID to PurchaseOrder.AddressID, this works but when I try to create the relationship from Address.AddressID to Invoice.AddressID the first relationship is deleted.and only the second remains.

Could you let me know if it's possible to do what I'm trying to do.

comments