Forum Discussion
Creating a Relationship Error
I have two tables with an invoice number being the unique field in both. When trying to create it comes up with the error message of ‘You can’t create a relationship between these two columns because one of the columns must have unique values’.
I've removed duplicate rows on both tables but the error message still comes up.
Has anyone had this problem before and if so would you be able to help?
Many thanks
Hi RossBateman
As a workaround, If the column has only number type value, you can change its type from "text" to "number",
Then add "prefix",
Then remove duplicates works.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Create a visual table or matrix, take invoice number and again take invoice and change aggregation to count.
Sort desc on Count of Invoice no. Make sure there is nothing having count more than 1
Thanks, it looks like this is the problem. The remove duplicate function doesnt seem to be romoving all of the rows! As I've got over 55k rows do you know of any other ways to delete duplicates?
Hi RossBateman
As tested, "remove duplicates" works on my side.
Please share some sample data for me to test and find a solution for you.
Best Regards
Maggie
