Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to query two tables with a linked record?

257 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,
Can someone help to create this query in Airtable?

Table 1 fields are:
FirmID
Firm
Country

Table 2 fields are:
Firm ID
Firm
Contact Name

Find all “Contact Names” from [Table2] where Country=“USA” in [Table1].
where FirmID is a one-to-many join.

Is there a way to do this in Airtable?
Thanks

0 Replies 0