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.
