# 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.

Source: https://tadabase.com/docs/get-started/getting-started-with-connections  
Status: Verified Nov 17, 2026. Checked against the current product

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.

> **Note:** Adding a connection field only makes linking possible. Each record is linked when someone picks the connected record, in the Data Builder or in a form.

## 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](https://tadabase.com/docs-shots/get-started-connection-field-settings.webp)

| Choice | Means | When you link a record |
| --- | --- | --- |
| **One Job belongs to one Customer** | Each job has one customer. Each customer can have many jobs. | You pick one customer. |
| **One Job belongs to many Customers** | A 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](https://tadabase.com/docs/pages/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

- [Add records](https://tadabase.com/docs/get-started/creating-records)
- Connection settings in detail: [Connect tables with connection fields](https://tadabase.com/docs/data/connection-fields) and [See how your tables connect](https://tadabase.com/docs/data/table-connection-graph)
