Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Break one table into many or leave alone?
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01433360
Message ID:
01433537
Views:
60
It's not possible to setup proper relationship in this case on the data level because any value in your lookup table would be valid as FK for other tables.

>Actually if your master lookup table has a good primary key, you use that for your RI and you are all set.
>
>I use a single table for all picklists on all of my systems.
>
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform