Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relations in SQL 2005
Message
 
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01353215
Message ID:
01353220
Views:
8
This message has been marked as the solution to the initial question of the thread.
You cannot link the same FK to 2 different tables.

>i've encountered a problem trying to add more relations to my database.
>in a nutshell i have 3 tables:
>
>T1.Pk and other columns
>T2.Pk and other columns
>T3.Pk and other columns
>
>i already have the following relations:
>Foreign key    /    Primary Key
>T2.Pk          /     T1.Pk
>
>i try to add
>
>T2.Pk          /      T3.Pk
>
>
>i get an error message to do with T3.Pk. All the Pk columns have the same basic properties.
>I tested this kind of relations on a different set of tables with the same result - i can't add a relation.
>
>Can you help?
>Tia
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform