Help

Lookup NonLinked Primary Column

Topic Labels: Base design
885 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Pixel_Designs
4 - Data Explorer
4 - Data Explorer

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 Reply 1

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.