Thanks all of you for the kind support.

I will get back to you once I will test these relationships.

Really, I was setting it up the opposite way.

So 3 foreign keys on Person_Information table to the same primary key Lookup_Country table will run perfectly fine.

ALTER TABLE Person_Information ADD CONSTRAINT...

Hi,

Thanks all for replying.. Its not an interview question.

Primary Key Table = Lookup_Country

Foreign Key Table = Person_Information

My question is that Can I create the following 3 keys referering to...

Thanks Ninja...

I have 50GB database without referrential integrity and lot's of table is having the same issue.

So, basically there is no solution... PK and FK should...

Thanks Ninja's for a quick...