Skip to main content

I have a table (let’s call it table1) that has a primary column called table1_id
I then have another table (let’s call it table2) that has a column which is a link to that table1_id value.
I then have another table (let’s call it table3) that has a column which is a link to that table1_id value.

How do I create a column in table1 that looks-up a value from table2 based on the row that table1_id is linked in. I feel like I need to do a lookup, but I can only do that on linked Values.

Welcome to the community, @Pixel_Designs!

Be sure that you are showing all of your fields in table 1 (i.e. no hidden fields).

When you create a link to table 1 from your other tables, Airtable will automatically create a reverse linked records field in table 1.

Use this reverse linked records field to create your lookup values.

Terms & ConditionsAccessibility statement