Forum Discussion

stavb's avatar
stavb
New Member
3 years ago
Solved

Filter table based on other filtered table

Hello community!

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

for example, i got:

table1

BankCountry
AUSA
BUSA
CUSA
AUK
DUK
DChina

 

table2

CountryDelivery
USAUPS
USAFedEx
UKUPS
UK Royal Mail
ChinaChaina 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 

USAUPS
USAFedEx
UKUPS
UK Royal Mail

 

 

Thanks in advance!

Need Help
  • Arul's avatar
    Arul
    3 years ago

    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

2 Replies

  • Arul's avatar
    Arul
    Super User
    3 years ago

    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