Lookup NonLinked Primary Column

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.

1 Like

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.