Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.