Good news: you can do it in just a few minutes!

Airtable doesn’t automatically sync values across tables, but it gives us powerful tools to make that happen: Linked Records, Lookup fields, and (for advanced users) Scripts.

Why link tables?

By linking tables in Airtable, you can:

• Pull data from one table to another (like a VLOOKUP in Excel).
• Display metadata or attributes without duplicating information.
• Keep your base tidy, scalable, and easy to maintain.

Example: Link the Products table to the Variants table

1. (Products table) Make Product ID the primary field

1. Open your Products table.
2. Locate the Product ID field.
3. Drag it to the first column position.
4. Click Change primary field to confirm.

2. (Variants table) Duplicate Product ID field

1. Open your Variants table.
2. Duplicate the Product ID field.
3. Keep “Duplicate cells” checked.
4. If needed, rename the new field (Product ID copy).

3. Convert the duplicate into a linked record

1. Select the new field you just created.
2. Change the field type to Link to another record.
3. Choose the Products table.
4. Save and confirm changes.
5. Skip Lookup fields (we will see it later)

4. Automate linking for new records

At this point, existing records are linked. But for new ones, you’ll want to automate the process.

1. Go to Automations in the top menu.
2. Create a new automation.
3. Trigger: When a record matches conditions.
4. Condition: In the Variants table, when Product ID is not empty.
5. Action: Update record → copy Product ID into the Product ID copy field.

✅ Every new Variant will now automatically link to its Product.

5. Add lookup fields

Now that the tables are connected, you can bring Product data into the Variants table.

For example, to display the Product Title:

1. Add a new field in Variants.
2. Select Lookup as the field type.
3. Source: your Product ID copy field.
4. Field: choose Title from the Products table.
5. Click Create field.

✅ Each Variant now shows its Product Title automatically.

🎉 You're done!

Your Variants table now shows data from Products table, automatically linked by Product ID. No manual copy-paste needed. Just clean, connected Airtable magic.

Updated on: 30/09/2025