Hierachy within the same Table

I am trying to create a hierarchical structure for different projects.
To simplify the whole thing let’s say there are 3 Tables: Categories → Project → Tasks

I would like to create a hierarchy within the Projects Table. As far as I know, it is not possible to create both-way sync within one table but I was hoping to achieve that with automation.

My current automation selects the parent ID and adds the record to the child column.
(To be more specific: The automation selects the original record + a lookup of the current child values and writes that in the child column)

The problem arises when I change multiple parent records at once.

Is there a better way to do that?
Ideally, I’d love to recreate the sync both ways option from Notion when linking a table to itself.

Thanks for the help already.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.