Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 first
  • I would guess that you have an indirect relationship between calendar and item name via some other tables.

2 Replies

  • I would guess that you have an indirect relationship between calendar and item name via some other tables.

    • Anonymous's avatar
      Anonymous
      Not 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