Im new at this, and have tryed to read the other solutions regarding the same queastion.
error : You Can´t create a relationship between these two columns because one of the columns must have unique values
The left table is where we have the absence on employees ( one person have 17 days, and the emplid is there 17 times)
The right table is where we have the employee stamdata (name, adress and so on) end the emplid is there only once.
In SQL server 2008 r2, there is no issue to relate these fields. what is the best way to set this up.
Solved! Go to Solution.
I have made sure that there isent any null, and empltable.emplid has 9307 pcs. of unique numbers 100001,100002 and so on.
it still dont work