@George I still think there’s something missing with the new db setup, please have a look.
I have a table schools with a cross ref table events which connects schools with events:
Here my table events:
I want to create the following query:
my issue: I want to do “school_events.id equal {{schoolid}}” (1) but I can’t do that because the that
school_events.id is in a subquery now instead of a join.
So I should be able to fix this by: joining school_events on events (used to be possible).
But now when I try to make the join:
I can’t select the school_events table
schools table where I can see the `schools.events as an option to pick but this doesn’t make sense.
Then it creates a join on schools.events (which is NOT a column, but it’s a multi-ref subtable as you can see in the very first screenshot). 
How can I create this join?
I think this issue is the same as the unresolved part in this thread: New db manager subtables - can't create the join I want?