Forum Discussion
cannot create a direct active relationship between two tables
Hi experts,
I have two tables, the column “Department “it has a fixed values in two tables and the column “Values “
Has a different values, when I tried to represent the data of two tables based on date, the data don’t shows and when I do the relationship between table 1 and table 2 this message appear “can't create a direct active relationship between two table, To make a relationship active, deactivate or delete one of the relationships between calendar table and table 2"
Because I have two relationships :
1 . Between table 1 and calendar table
- Between table 2 and calendar table
Can anyone help me,how to fix it .
Hello Lolo_2023
Thank you for explaining your model. Based on your description, I would recommend adding a Department dimension table. You can then link this Department table to both Table 1 and Table 2, instead of directly connecting Table 1 to Table 2.
To create the Department table, you can simply use the `DISTINCT` function on the department column.
2 Replies
Hello Lolo_2023
Thank you for explaining your model. Based on your description, I would recommend adding a Department dimension table. You can then link this Department table to both Table 1 and Table 2, instead of directly connecting Table 1 to Table 2.
To create the Department table, you can simply use the `DISTINCT` function on the department column.
Thank you, it works
