Forum Discussion
How to solve ambiguity between tables
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!
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.
4 Replies
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.
