Problem in creating a relationship in sql server 2005: Newbie

  • Thread starter Thread starter weird0
  • Start date Start date
W

weird0

I created a new Diagram and chose the tables that i wanted to create
relationships between.
When I wished to create a relationship between CUSTOMER and
CC_TRANSACTIONS
or say any other table........ it gives me the following message:

" The columns in table 'CUSTOMER' do not match an existing primary
key or UNIQUE constriaint."

Any idea what that mean. Need help as to how to fix it so i create a
relationship and get coding.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
SQL Server 2005: Creating a relationship between two tables 1
Access 2010 Form Issue's 0
Where should relationships be created? 8
One to one relationship 0
Disappeared Relationships; Can't Recreate 2
Access Command button to look up and copy data from a query to a table 0
Add relationships between tables c# VS2005 Server Explorer 2

Back
Top