Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Feb 04, 2022 09:36 AM
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.
Feb 04, 2022 06:57 PM
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.