Connect tables with connection fields

Add a connection field between two tables, choose whether a record links to one or many records, then connect the actual records.

  • Verified Nov 17, 2026
  • Classic builder

On this page
  1. Decide which table gets the field
  2. Add a connection field
  3. Connect the records
  4. See how tables connect
  5. Next steps

A connection field links records in one table to records in another, such as each job to its customer. You store the customer's details once, and every job shows them through the connection.

Decide which table gets the field #

Add the connection field to the table whose records belong to the other one. A job belongs to a customer, so add the field to Jobs and point it at Customers. The customer can still list all of its jobs through the same connection.

Add a connection field #

  1. Open the table In the Data Builder, open the table that gets the field (for example Jobs).
  2. Start a new connection Click the Connections tab, then Add New Connection. On the Fields tab you can also click Add New in the Connections panel.
  3. Pick the other table In Jobs connects to (the label uses your table's name), pick the table to connect to, such as Customers.
  4. Choose the relationship Click one of the two boxes. Each box reads in plain words, for example One Job belongs to one Customer or One Job belongs to many Customers.
  5. Choose the display field In Display Field, pick the field that names each connected record, such as the customer's name. It starts with the other table's Default Display Field.
  6. Name it and save Check the Name (and add a Description if you like), then click Save.
The settings of the Customer connection field on the Jobs table, showing the connected table and the two relationship choices
ChoiceMeansWhen you link a record
One Job belongs to one CustomerEach job has one customer. Each customer can have many jobs.You pick one customer.
One Job belongs to many CustomersA job can have several customers, and a customer can have many jobs.You can pick several customers.

When the connection points to the Users table, you can turn on Auto assign to logged-in user: a record saved with this field empty is connected to the person who saved it.

Connect the records #

  • In the Data Builder: open a record on the Records tab. The connection field is a picker that lists the other table's records by their display field. Pick one (or several) and click Save.
  • In your app: add the connection field to a form. People pick the connected record when they add or edit a record. See Form component.

See how tables connect #

A table's Connections tab shows its outgoing and incoming connections, in Visual, List and Diagram views. On the Records tab, the Show Relation Graph button opens a graph of the tables this one connects to.

Next steps #

Was this page helpful?

Something wrong or missing on this page? Tell us.