Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relations in SQL 2005
Message
From
07/10/2008 08:00:24
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Relations in SQL 2005
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01353215
Message ID:
01353215
Views:
46
Hello
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
A moment of silence is our cosmic reset button.
Next
Reply
Map
View

Click here to load this message in the networking platform