Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Relationship

Hi,

Can someone help me here. I am trying to create a trelationship between "SALES" and "BUDGET" but it is not working.

I don't want a MANY TO MANY Relationship. Thanks in Advance

  • Hi Anonymous 

    If you want a 1-to-many relationship you need to eliminate the duplicates on the the table on the 1 side, in the column you want to use for the relationship.

     

    Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion

    Hi Anonymous 

    If you want a 1-to-many relationship you need to eliminate the duplicates on the the table on the 1 side, in the column you want to use for the relationship.

     

    Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.