is it possible to create a foreign key in SQL Server wherein the
fields being define as the reference is not a primary key?
Printable View
is it possible to create a foreign key in SQL Server wherein the
fields being define as the reference is not a primary key?
Try creating a unique constraint on the referenced column. Even though I can't find where I've done this before, I'm pretty sure it will work.
Chris
We cannot create the unique constraint because the records in the fields are not unique either. we could have easily defnied them as primary key if they weren't.
Thanks for your help anyway.
:D