Unable to set up the relationship between two tables

[harshadrokade]

Hi friends,

I have created a relationship as below where table A and B are indirectly connected.

I want to create diect relationship between these two tables& so I created a direct relationship. When I try to activate this relationship, I see below error as shown on relaionship activation. Can you pls help me to know how this can be handled.

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, you should create another single column table of Team C (Table C).  Now create a relationship from Table A and B to Table C.

Hope this helps.

[parry2k]

How easy it is for both of us if share relationship diagram, no? Why not do it? 

[harshadrokade]

What exactly u mean by relationship diagram? Thanks for ur help

[parry2k]

@harshadrokade seems like you have another table in the model that is connected to these two table and that could be the reason as the message suggest. Share full relationship diagram screenshot

[harshadrokade]

thanks for your reply @parry2k . These are the only tables I have an these are the only relationships I have created. The same is shown in the screenshot. Thanks.