Forum Discussion
Can´t create a relationship between two columns because one of the columns must have unique value
KSveigaard basically what that error is complaining about is that relationship you're trying to create from column within 'FROM' table to your column in 'TO' table has issue. one of that column must have unique product numbers. you can't have Many to Many relation but only One to Many or Many to One relation. So ensure that one of the table has unique product numbers and then there won't be any issue.
Advocate II had the same problem, turned out I had a blank row at the bottom of the table which was giving out a reading of 'null' and stopped the relationship working.
I deleted the null row and it work after that, although it only worked when I dragged the relationship one way round and not the other so try setting up the relationship both ways if the first one doesn't work. Not sure why this would be though
Advocate IMy data source is from mysql and the field that I use to create relation is primary key of this table. I'm sure that there is no blank row in this table.
I'm stuck with this for a week and still have no solutions for this problem. poor me