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