Forum Discussion
Relationship issue when i have unique values
Hi Experts Refer to table dimdata and hierarchy both tables have ItemID. I have unique values in Hierarchy table and multiples in dimdata... When I try and create an 1 to * relationship its t...
Fowmy
Super User
Super UserAnonymous
When you are creating a relationship as one-to-many, the one side of the relationship must have unique values. In your hierarchy table, there are duplicates 3a and 3b. Remove duplicates and it should work.
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Many thanks for excellent feedback