You could create a single table for all the locations independent of the level. In that table, you create a parent field so each record could point to its up level. Then create a path field to hold the whole item hierarchy. This will allow you to fil...

You could create a single table for all the vertices of your site. In that table create a parent field so each record could point to its up level. Then create a path field to hold the whole item hierarchy. This will allow you to filter and order the ...

I proposed a solution here.

I had a similar problem trying to organize my projects and tasks in a multi-level structure. I’ve tried some solutions: 1 - You can have a table for each level all linked by a parent field and group items in each table by their parent. This is easy t...