Filter table based on other filtered table

[stavb]

Hello community!

I need help filtering a table based on the selected values from another table.

for example, i got:

table1

Bank	Country
A	USA
B	USA
C	USA
A	UK
D	UK
D	China

table2

Country	Delivery
USA	UPS
USA	FedEx
UK	UPS
UK	Royal Mail
China	Chaina mail

I want to be able to choose/filter bank A (for example), and be able to see all the Delivery companies in countries where there's bank A.
so if I choose Bank A, it wil show me 

USA	UPS
USA	FedEx
UK	UPS
UK	Royal Mail

Thanks in advance!

[stavb]

thanks!

[Arul · Accepted solution]

@stavb ,

1. Create the relationship between Table 1 Country column to Table 2 Country column, FYI - It will create the Many to Many relationship between the tables since we have multiple countries in country column.

2. Output,

Thanks,

Arul