Nested Lookups (a lookup within a lookup of a linked field)


#1

I think being able to lookup within a lookup of a linked field would be quite useful. For example, I have three tables: “Projects”, “Shipments”, and “Clients”. There can be multiple projects per client, and there can multiple shipments per project. I want to display the Client contact information on the “Shipments” table, but as the client name auto-populates using a lookup field, which pulls the name from a linked field on the “Projects” table, I cannot look within this lookup of a linked field. I can only get the desired result if I re-enter the Client data on the “Shipments” table via a linked field directly to the “Client” table, which is not only tedious but leaves room for error.

If anyone knows of a better way to do this, please let me know. If anyone from Airtable can add this functionality, it would also be great.