Forum Discussion
Solved
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...
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.
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