Forum Discussion
How to solve relationship with circular reference?
Hello all! I am struggling to get a solution for the following problem. Any help will be hugely appreciated! I have two tables to work with: Table 1: contains a list of items. One column ...
Table 1:
Table 2:
One expected result:
(this is as far as I where I was able to get by duplicating the tables)
On the list, one project is selected, and on the pizza, all tasks and subtasks directly linked to this project are filtered.
However, I would also like to retrieve all subtasks linked to this project (including the one directly linked and any others indirectly linked through the 30 tasks). Furthermore, if I select the "tasks" on this pizza, I would like to be able to filter all its subtasks on a different pizza or drill through this one.