# Connect tables with connection fields

> Link records in one table to records in another with a connection field: plan the relationship, add it, and edit or remove it later.

Source: https://tadabase.com/docs/data/connection-fields  
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 the Customer it is for. Once two tables are connected, a job can show its customer's details, and a customer can list and total its jobs.

## Plan the relationship

Add the connection field to the table whose records belong to the other one. Each job belongs to a customer, so the connection goes on **Jobs** and points to **Customers**. You only add it on one side: the other table sees it as an incoming connection.

| Choose | When | Example |
| --- | --- | --- |
| **One-to-One** | Each record connects to one record of the other table. | One Job belongs to one Customer. Each Customer still has one or many Jobs. |
| **One-to-Many** | Each record can connect to several records of the other table. Use it for many-to-many relationships too. | One Job has many Technicians, and each Technician has many Jobs. |

## Add a connection

1. **Open the table** In **Data Builder**, click the table that will hold the connection (Jobs in the example) and open its **Connections** tab.
2. **Start the connection** Click **Add New Connection**. You can also add it from the **Fields** tab with **Add New Field** and the **Connection** field type.
3. **Pick the other table** In **Jobs connects to** (named for your table), choose the table to connect to.
4. **Pick the relationship** Click **One-to-One** or **One-to-Many**. The card shows the relationship in words, such as "One Job belongs to one Customer".
5. **Choose the Display Field** Pick the field of the other table that people see when they choose a record, such as the customer's name. It starts as that table's **Default Display Field**.
6. **Name and save** Give the field a **Name** and, if you like, a **Description**, then click **Save**.

## Connection field options

| Option | What it does |
| --- | --- |
| **connects to** | The table on the other side of the connection. |
| **One-to-One** / **One-to-Many** | Whether a record connects to one or to several records of the other table. |
| **Display Field** | The other table's field shown for a connected record. It only changes what people see: you can change it at any time without changing which records are connected. |
| **Name** and **Description** | The field's name in this table, and a note for builders. |
| **Auto assign to logged-in user** | Only for connections to the Users table. When a record is created or edited and this connection has no value, it is set to the logged-in user. An existing value is never overwritten. |

## See a table's connections

The **Connections** tab of a table has three views:

- **Visual**: cards for each connection, under **Outgoing (belongs)** for the connections on this table and **Incoming (has)** for connections from other tables to it.
- **List**: the connection fields grouped by the table they link to.
- **Diagram**: a graph of this table and the tables linked to it.

![The Connections tab of the Jobs table in the Visual view, with its outgoing connections to Customers and Technicians](https://tadabase.com/docs-shots/data-connections-tab.webp)

For a map of every table in your app and how they link, see [See how your tables connect](https://tadabase.com/docs/data/table-connection-graph).

## Connected and related records

Records are **connected** when a connection field links them directly, such as a Job and its Customer. They are **related** when they link through another table: if Job Notes connect to Jobs and Jobs connect to Customers, a customer's job notes are related to the customer. A customer's details page can show both its connected jobs and those related notes.

To total or count connected records, such as the number of jobs per customer, add a rollup or equation field. See [Rollup](https://tadabase.com/docs/data/rollup) and [Calculate values with an Equation field](https://tadabase.com/docs/data/equation).

## Edit or remove a connection

- **Edit:** on the **Connections** tab, click the connection's card (or its pencil in the **List** view) to open the field. Change its options and click **Save**.
- **Remove:** open the field and click **Delete**. The field moves to **Deleted Fields**, where you can restore it. See [Restore a deleted field](https://tadabase.com/docs/data/deleted-fields).
