Forum Discussion
Anonymous
3 years agoNot applicable
relationship between tables
Hello, I hope all is well with everyone.
My question is the following, I have these three tables, (item name, UX_salesview, calendar), and I connected the calendar table to the UX_saleview table without problem, but when connecting the Item Name table with UX_saleview it gives an error because it says that it causes ambiguity with the Calendar table.
If anyone could help?
The translation of the yellow rectangle - "Cannot create a direct active relationship between UX_SalesView and ItemNames because that would introduce ambiguity between Calendar and UX_SalesView tables. To make this relationship active, disable or drop one of the relationships between Calendar and UX_SalesView firstI would guess that you have an indirect relationship between calendar and item name via some other tables.
2 Replies
- johnt75Super User
I would guess that you have an indirect relationship between calendar and item name via some other tables.
- AnonymousNot applicable
I went back to doing the relations trying to see if it had any indirect relation with the calendar and it already worked, I don't know if it has to do with what you said, but thanks