Navigation

Navigation properties let you walk from a record to the records related to it, and read the related records inline, without writing a join.

Drill into a related record

In the results grid, a column that represents a related record renders each cell as a navigation chip labelled with the related record’s name. Click it to open an inline detail strip directly beneath that row:

• The strip shows the related record’s properties as a grid, so the relationship is read in place.
• A related record that itself has relationships shows further navigation chips, so the chain can be followed several levels deep.
• Each open strip is anchored under its own row, and several strips can be open at once, each showing its own row’s related record.

Relationships in the tree

The connections panel’s schema tree groups a table’s relationships under a Relationships group. Each relationship is its own row with a direction glyph, the related table’s name, the direction label, and via <column>, so you can see how two tables are joined before you write a script.

Edit a related record

A navigation strip can be toggled into edit mode with Edit this strip (in the strip header, beside Close). Inside an opened strip, further navigation affordances are rendered read-only — the nested drill-in boundary — so a change is always made from the strip you explicitly opened for editing. A read-only connection gates the same edit affordance with a clear reason.

Depth and cycles

DataPad tracks the navigation path so a chain cannot loop forever. When a record is already open on the current path, its chip is blocked with a reason naming the cycle (for example ”… is already open in this navigation path …”) rather than opening a second copy. The depth is shown on each strip (for example depth 2 of 8), and the limit is honoured rather than exceeded.