Airtable Relational Data & Linked Records
How to model real-world relationships — customers, orders, products.
Lesson Notes
Relational data is the difference between a toy database and a real one. In Airtable, a Linked Record field creates a relationship between two tables — like "this Order belongs to this Customer." Lookup fields pull data from the linked record into the current table. Rollup fields aggregate across linked records (count, sum, average). This is the mental model you need before moving to Xano, Supabase, or any real backend — the concepts are identical, just with SQL under the hood.
Your Challenge
+15 XPIn your Airtable base, add a second table called "Orders". Link each Order to a Product using a Linked Record field. Add a Rollup field on the Products table that counts how many orders each product has. Build a view that filters to only show products with more than 2 orders.