Filter based on two column values

[emnd]

Hi,

I have two tables:

TABLE 1

Columns 1          Column 2    

Item 1                   A                        

Item 2                   B                       

Item 3                   C                         

TABLE 2

Column 1          Column 2      

Entry 1                   A                         

Entry 2                   B                         

Entry 3                   C                         

Entry 4                   A                         

Entry 5                   B                         

Entry 6                   C                         

I want to filter TABLE 2 based on BOTH column values of the selection in TABLE 1. E.g., If I select "Item 1" in TABLE 1, I want to see Entry 1 and Entry 4 in TABLE 2, because they both have "A" in column 2.

Anyone who can help?

[waltheed · Accepted solution]

If you create a relationship between these two tables on 'Table1'.[Column 2]  = 'Table2'.[Column 2] then this works as you want. 

[emnd]

Thanks! That solved my problem 🙂