How to Link Tables in Airtable (2026 Guide)

AirtableProductivityHow-toDatabasesNo-Code

Airtable’s linked record field is what makes it a database instead of a spreadsheet. Once two tables are connected, you can pull values across them with lookups, aggregate with rollups, count related records, and build many-to-many relationships using junction tables. Here’s how to set up each kind of link in 2026, plus when to use Airtable Sync instead.

The Linked Record field is the foundation of every relationship in Airtable. It stores references to records in another table, not copies, so when the linked record changes, your link stays accurate.

  1. Open the table you want to link from (for example, Tasks).
  2. Scroll to the right end of the field row and click the + to add a new field.
  3. In the field type list, search for and select Link to another record.
  4. In the Which table? dropdown, select the table you want to link to (for example, Projects).
  5. Decide whether each record should link to one record or multiple records. By default Airtable allows multiple, uncheck Allow linking to multiple records if you want a strict one-to-one relationship.
  6. Optionally, check Limit record selection to a view to restrict which records can be linked (useful when you only want active items to show up in the picker).
  7. Click Create field.
  1. Click any cell in the new linked field.
  2. Start typing, Airtable searches the linked table by its primary field (the first column).
  3. Click a record to add it. To add another, type and select again. To remove, hover the chip and click the x.
  4. Click the expand arrow on a chip to open the linked record in a side panel and edit it without leaving the current view.

Two-way linking

Airtable creates a reciprocal field on the other table automatically the first time you link two tables. So if you link a task to a project, opening the project shows that task in a linked field on the Projects side. You can rename either field without breaking the link.

The primary field matters. Airtable shows the primary field of the linked table when you search for records to link. If your primary field is “Notes” and every row says the same thing, you won’t be able to tell records apart in the picker. Use a unique, human-readable primary field, a name, an ID, a title, for any table you plan to link from.

2. Pull Data Across Tables with Lookup, Rollup, and Count

A linked record on its own only stores the connection. To actually display or calculate values from the other table, add one of these three field types.

Lookup field

Pulls a specific value from each linked record.

  1. Click + to add a new field.
  2. Select Lookup.
  3. Choose the linked record field (for example, Project).
  4. Choose which field on the linked table to display (for example, Project owner or Status).
  5. Click Create field.

Lookups update automatically when the source value changes.

Rollup field

Aggregates values from multiple linked records using a formula.

  1. Add a new field and select Rollup.
  2. Choose the linked record field, then the field on the linked table to aggregate.
  3. In the formula box, write an aggregation: SUM(values), AVERAGE(values), MAX(values), MIN(values), ARRAYJOIN(values, ", "), or COUNTA(values).
  4. Click Create field.

Use rollups when one record links to many, for example, summing hours logged across all tasks on a project.

Count field

Returns the number of linked records in each row. No formula needed.

  1. Add a new field and select Count.
  2. Choose the linked record field.
  3. Click Create field.

Use count for quick metrics like “tasks per project” or “deals per account.”

3. Build a Junction Table for Many-to-Many Relationships

A linked record field already supports many-to-many, each record can link to multiple records on either side. But when the relationship itself has data (start date, role, status, hours), you need a junction table.

Example: People assigned to Projects

  • People table, one row per person.
  • Projects table, one row per project.
  • Assignments table (junction), one row per person-project pairing, with linked fields to both People and Projects, plus its own fields like Role, Start date, Hours per week.

Set it up

  1. Create the third table from the + in the table tabs row.
  2. Add a Link to another record field pointing to the first parent table.
  3. Add a second Link to another record field pointing to the second parent table.
  4. Add any fields that describe the relationship itself.
  5. Set the primary field to a formula that combines the two linked fields, for example: {Person} & ", " & {Project} This makes each row uniquely identifiable when you link to it from elsewhere.

The junction table pattern is what relational databases use under the hood. In Airtable it’s just three tables and two linked fields.

4. Sync a Table from Another Source

If the table you want to link to lives in another base, or in Google Sheets, Salesforce, Jira, Zendesk, or a CSV at a URL, you can pull it in as a synced table instead of duplicating data.

Set up a sync

  1. In the base sidebar, click Add or import > Sync data.
  2. Choose a source: Airtable base, Google Sheets, Salesforce, Jira Cloud, Zendesk, Box, CSV from URL, Microsoft Excel, or others.
  3. Authenticate the source.
  4. Pick the view or sheet to sync.
  5. Choose which fields to include and click Sync.

The synced table appears as a new tab. Records refresh automatically (or on demand for some sources). You can add a Linked Record field on any of your other tables that points to the synced table, and use lookups and rollups against it normally.

Plan gating. Sync from external sources (Google Sheets, Salesforce, etc.) requires a Team plan or higher. Cross-base syncs also require a paid plan. CSV import (a one-time copy, not a live sync) works on Free.

Quick Reference

GoalUse
Connect two tables with a relationshipLinked Record field
Show a value from the linked recordLookup
Aggregate values across multiple linked recordsRollup
Count how many records are linkedCount
Relationship has its own metadataJunction table with two linked record fields
Pull a live copy of a table from another base or appSync (Team plan or higher)

Which Method Should You Use?

  • One record relates to one or many records in another table? Linked Record + Lookup is enough.
  • Need totals, averages, or other aggregations? Add a Rollup.
  • Each relationship needs its own fields (date, role, hours)? Build a junction table.
  • Source data lives in another base or another app? Use Sync, then link to the synced table.

Keep Linked Records Updated Without Doing It Manually

Once your tables are linked, the next problem is keeping records current, adding new rows from emails, updating statuses based on calendar events, syncing assignments from other apps. Carly is an AI assistant that connects to 200+ apps including Airtable and handles those updates for you in plain English.

More Airtable guides: How to create a form in Airtable · How to import a CSV to Airtable · How to export Airtable to Excel · Best AI workflow automation tools

Ready to automate your busywork?

Carly schedules, researches, and briefs you—so you can focus on what matters.

Get Carly Today →

Or try our Free Group Scheduling Tool or Free Booking Page

Related Articles

Guides

How to Create a Form in Airtable (2026 Guide)

Guides

How to Create a Database in Notion (2026 Guide)

Guides

How to Export Airtable to Excel (2026 Guide)