>>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.
>>
>
>How would you set it up then to only connect main table with right entities?
Picklists
pk int (identity) (primary key)
Picklist_Name varcar(50)
Picklist_Display varchar(50)
Picklist_Display_Order smallint
Data Table
field1
field2
field3
Picklist_code int (fk is pk on Picklists table)
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________