The columns in table <Tablename> do not match an existing primary key or UNIQUE constraint. (Visual Database Tools)

The columns on the primary key side of a foreign key relationship must participate in either a Primary Key or a Unique Constraint. After setting up a Primary Key or a Unique constraint for one of the tables you've selected, you can then define other relationships for that table.

For more information, see How to: Create Unique Constraints (Visual Database Tools) and How to: Create Primary Keys (Visual Database Tools).

See Also

Concepts

Error Messages in Visual Database Tools

Help and Information

Getting SQL Server 2005 Assistance