Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

A pair of matching columns is required to create a relationship. (Visual Database Tools)

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.

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.

For more information, see FOREIGN KEY Constraints and How to: Create Relationships Between Tables (Visual Database Tools).

Community Additions

© 2015 Microsoft