>Hi All, I want to create a ( in Fox terms ) relation between two tables in my database , one is Address with a pk of AddressID the other Customer with a foreign key AddressID , many Customers can have the same AddressID , this what I've tried in SSMS
>
>ALTER TABLE address ADD CONSTRAINT FKAddress_Customer FOREIGN KEY
>(
>AddressID
>
>) REFERENCES Customer(AddressID)
>
>
>but I receive the error
>
>Msg 1776, Level 16, State 0, Line 1
>There are no primary or candidate keys in the referenced table 'customer' that match the referencing column list in the foreign key 'FKAddress_Customer'.
>Msg 1750, Level 16, State 0, Line 1
>Could not create constraint. See previous errors.
>
>the customer AddressID is indexed and not nullable so I don't understand why it doesn't work.
"FOREIGN KEY constraints can reference only columns that are PRIMARY KEY or UNIQUE constraints in the referenced table or columns referenced in a UNIQUE INDEX on the referenced table" - see at
http://technet.microsoft.com/en-us/library/ms174979%28v=sql.105%29.aspx