How to use Airtable linked records and lookup fields

A short tutorial for creating Airtable linked records

5 min read
Dec 31, 2024
Author
Matthew Busel

Matthew is the co-founder of Whalesync.

Share
Copy Link

This short guide will teach you:

  1. How to create an Airtable linked record field
  2. How to create an Airtable lookup field


In the demo below, we’ll create a linked record between a “Contacts” table and a “Companies” table so that you can associate contacts to their respective companies.



Step-by-step Airtable linked records guide

1) Ensure you have at least two tables in Airtable

In this case we have a “Contacts” table and a “Companies” table.


2) Click the “+” button to add a new field


3) Click “link to another record”


4) Click the name of the other table

In this case we’re in the “Contacts” table so we’ll click to link to “Companies”.


5) Click “create field”


6) Link records by clicking into the field and selecting records


7) To add a lookup field, click the dropdown arrow in the field


8) Click “Add lookup fields”


9) Choose the lookups you want and click “Add fields”


🎉 and there you go! Now you know how to add linked record and lookup fields in Airtable.


Video tutorial

Watch below for a 2 min video tutorial on adding linked records and lookup fields.


Lookup fields vs Rollup fields

Once you understand Airtable lookup fields, the next step is understanding Airtable rollup fields.


You can also watch a short explainer covering the difference between lookups and rollups as part of our Airtable 101 course.

Subscribe for more

Stay up to date with the latest no-code data news, strategies, and insights sent straight to your inbox!

Thank you for subscribing!

Oops! Something went wrong while submitting the form.
Keep reading

Related posts

Jul 8, 2025

How to connect and sync Sheets to Stripe in 5 minutes with Whalesync

Read post
Jul 3, 2025

How to connect and sync Notion to Stripe in 5 minutes with Whalesync

Read post
Jul 3, 2025

How to connect and sync Supabase to Attio in 5 minutes with Whalesync

Read post
Jul 1, 2025

How to connect and sync Notion to Attio in 5 minutes with Whalesync

Read post
Jun 30, 2025

How to connect and sync Airtable to Attio in 5 minutes with Whalesync

Read post
Jun 29, 2025

How to connect and sync Airtable to HubSpot in 5 minutes with Whalesync

Read post

Start syncing in minutes