Error when building Relationship

[h4_dkj]

Hi

I have a case where i have one table that lists all projects, Workforceproject. and one that lists all users, Users

In Workforceproject a user can be owner on many projects.

In Users A owner can only be part of one department.

Now I am trying to build a relationship between these to on field owner I want to set a many to 1. 

My goal is to build a report where I now can filter my main projects  by department.

However when i Build it I get this error saying that I can only use many to many.

That does not work for me.

It seems that since I have owners in Users that do not exist in Workforceproject it fails?

Please advise

Thanks

[olgad]

@h4_dkj Have my answer or you yourself solved your problem? If so, can you please share your solution or accept my answer as Solution to help other members find it faster? Thank you very much for your kind cooperation!

[olgad]

Please check if you have any blanks or nulls in your User Table in the User column.

Also, you can go to Transform Data, right click on User Column in User Table, pick option remove duplicates.