A pair of matching columns is required to create a relationship.

Message Text

A pair of matching columns is required to create a relationship.

Explanation

You must select matching columns from both tables participating in a foreign key relationship. The columns you have selected don’t match, so they cannot be related.

Action

Choose two columns that match, then attempt to establish the relationship. In order to match, there must be the same number of columns and each partner in a pair of columns must have a comparable data type.

See Also
ALTER TABLE How to add related tables to a database diagram (Enterprise Manager)
Constraints How to create a FOREIGN KEY constraint using a database diagram (Enterprise Manager)
CREATE TABLE How to view the foreign key attributes of a relationship (Enterprise Manager)
Creating and Modifying FOREIGN KEY Constraints Key Object
Designing Tables SQLForeignKeys
Foreign Key Constraints  

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.