Tables & field types — Connect tables with Relation, Lookup, and Rollup

Relation fields link to other tables. Lookup fields pull a value from a linked record. Rollup fields aggregate values from records that link to this one. • Relation — choose which table this connects to. In the grid, each link renders as a chip you can click to peek at the linked record. • Lookup — pick the route to follow from a dropdown (directly-linked tables first, deeper routes grouped by how many relationships they cross), then pick which field it should pull in from a second dropdown of that table's fields. Everything is chosen by name — there is nothing to type.