Skip to main content

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

Be the first to reply!