Relationship Question

[Anonymous]

Hello,

Im having some trouble with creating a certain relationship between my tables. I'm not entirely sure what I am doing wrong here, but would like to learn so that I can correct the issue.

I have one table like this that shows Departments: 

Department

Finance

Operations

T&I

HR

Operations

BD/Com

HOS

Environmental Leadership

Then I have several other tables that look like this one below. Some information removed for confidentitaly. 

Employee's Name	Department	Position Title	Adjustment
	Finance		46
	Operations		40
	Operations		60
	T&I		97
	Finance		97
	Operations		74
	T&I		40
	HR		6
	Operations		93
	BD/Com		81
	T&I		99
	HR		99
	Operations		93
	BD/Com		34
	Operations		93
	Operations		29
	Operations		74
	HOS		97
	Environmental Leadership		93
	T&I		87
	HOS		67
	Environmental Leadership		81
	Environmental Leadership		81

What im trying to do is create a relationship between the department in the first table, and this department in the second table. However, whenever I try to create a relationship it gives me the error, "you cant create a relationship between these two columns because one of the columns must have unique values." Im not entirely sure why this is happeneing. Wouldnt it just be a "one ot many" relationship? Any help would be appreciated!

Thank you!

[amitchandak · Accepted solution]

In visualization, create a matrix on department and count of the department from department and sort on the count to see if there are more than values there

[Anonymous]

That seemed to be the problem! Im not sure why it wouldnt have defaulted to a many to many relationship, but once your fix was applied it allowed me to do a one to many instead of giving me an error.

Thank you!