Linked records, lookups and rollups

A Linked record field connects a record to records in another table, for example a candidate to the job they applied for. The link works both ways: the other table gets a matching field that shows the records linking to it.

Lookups

A Lookup field shows a field from the linked records. On a Candidates table linked to Open roles, a lookup can show each candidate’s role title without copying it.

Rollups

A Rollup field summarises the linked records, for example counting the candidates for each open role or adding up the value of a customer’s orders.