How to solve ambiguity between tables

[o59393]

Hi all

I am doing a relatinship model between 3 tables. One contains the objetives, the other the name of the business unit, and the other is a catalog of facilities.

When I link the BU table with the facilities I get an error like this:

I cant activate the relationship because of an ambiguity between Bu table and complaints table. However complaints table is not linked to bu (seen on image).

How can I get the relationship active?

I attach the 3 sources.

Facilities https://www.mediafire.com/file/fzyv1ojoc237vef/facilities.csv/file

Bu https://www.mediafire.com/file/0d2j3d6zfdf7fv9/BU.csv/file

Objetivos https://www.mediafire.com/file/5gukp2b9zuxg6b7/matriz_objetivos_bu.csv/file

Thanks!

[d_gosbell · Accepted solution]

Your issues is not specifically between those 3 tables. The thing causing the ambiguity is the bi-directional one-to-one filter between objectives and date. If you change this relationship to a single direction one-to-many relationship the same as all the other relationships coming off date this would fix your issue and you would be able to activate the other relationship.

[o59393]

Thanksssss

Like this right?

Regards!

[d_gosbell]

The screenshot is a bit cut off, but that looks like what I was thinking

[o59393]

Thanks @d_gosbell