Help

How to query two tables with a linked record?

772 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Vish_Bhatia
4 - Data Explorer
4 - Data Explorer

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