I want to have two tables with columns referring to each other that I can easily edit from both perspectives. As far as I know, this is only do-able by setting up automation that updates the other perspective if I edit one side. Given both scaling and the fact that automation is delayed, I would prefer a solution that isn’t relying on it.
So, formally, is there a way to define a Lookup From Table Column on two tables that reference each other (E.g.: Parent, Children; so for both One-X and Many-X relationships), that is assignable on both without using Automation?
As an example, see the following embed where I use a Lookup Table column to define Parent & Children relationships, but a formula to populate one end.
The issue however is that I can only easily change the “Parent”, through the “Assign Parent to Subtasks” view. However, I cannot change the “Children” through the “Assign Children of Subtasks” view.