# Linked records, lookups and rollups

> Connect tables with linked records, then show values across them with lookups and summarise them with rollups.

Source: https://docs.formclick.io/databases/database-linked-records

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.