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.

  • Verified Nov 22, 2026
  • Classic builder
  • Tadabase AI

On this page
  1. Many-to-many
  2. When the link changes over time

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 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 and Getting started with connections.

Was this page helpful?

Something wrong or missing on this page? Tell us.