>MS SQL Server gives an error msg 1776 if foreign key is referencing
>part of a primary key.
> Master Table
> Address (Address_id int,
> Seq_no identity,
> Descr varchar(50)) with PK (Address_id, Seq_no)
> Dependant table
> Contact (Contact_id int,
> Address_id int,
> Contact_name varchar(30)) with PK Contact_id
>I want to make Foreign Key on Contact(Address_id) Referencing
>Address(Address_id). Can someone HELP ????
>PS: don't ask to add a column Seq_no in Contact table
requires that the referenced table be unique within the reference
columns. Since your Address records are not necessarily unique by just
the Address_ID, you can't create a foreign key on just that column. In
short, what you're trying to get is not a foreign key. What are you
trying to accomplish by putting that foreign key in? Better access
times? In that case, try just adding an index on that field.