topic Re: Unable to set up the relationship between two tables in Desktop

Unable to set up the relationship between two tables

harshadrokade — Mon, 11 Sep 2023 17:53:34 GMT

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.

Re: Unable to set up the relationship between two tables

parry2k — Mon, 11 Sep 2023 18:19:34 GMT

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

Re: Unable to set up the relationship between two tables

harshadrokade — Sat, 16 Sep 2023 04:30:48 GMT

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.

Re: Unable to set up the relationship between two tables

parry2k — Sat, 16 Sep 2023 04:36:05 GMT

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

Re: Unable to set up the relationship between two tables

Ashish_Mathur — Sat, 16 Sep 2023 05:31:27 GMT

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.

Re: Unable to set up the relationship between two tables

harshadrokade — Thu, 05 Oct 2023 18:02:04 GMT

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