# How do I link tables, like one customer with many orders?

> Add a connection field. It links records in two tables, works in both directions, and supports one-to-one, one-to-many and many-to-many relationships.

Source: https://tadabase.com/docs/faq/how-do-i-link-tables  
Status: Verified Nov 22, 2026. Checked against the current product

Add a connection field: open the table whose records belong to the other one (Orders), go to its **Connections** tab, click **Add New Connection**, pick the other table (Customers) and choose **One-to-One** or **One-to-Many**. The link works both ways: each order shows its customer, and each customer can list and total its orders.

## Many-to-many

With **One-to-Many**, each record can connect to several records of the other table, so it also covers many-to-many cases such as students and classes. To count or total connected records, add a [Rollup](https://tadabase.com/docs/data/rollup) field.

## When the link changes over time

If you need to keep who owned what and when, such as owners of a property, add a table in between. An **Ownerships** table connects to one Owner and one Property and holds a start date, an end date and a Decision Box field called Current. Each owner is stored once, and the history stays.

Full steps: [Connection fields](https://tadabase.com/docs/data/connection-fields) and [Getting started with connections](https://tadabase.com/docs/get-started/getting-started-with-connections).
