Relationship

[Gaucho]

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

[AlB · Accepted solution]

Hi @Gaucho 

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.