>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?
If it's not broken, fix it until it is.
My Blog