Query with sum of criterias

[rasco22862]

Hello! I have a Folder table like this:

Id/Name/Client
1/Aaaa/ASD
2/Bbbb/FGH
3/Cccc/FGH
4/Dddd/ASD
5/Eeee/ZXC

...and a Clients table like this:

Id/Client/Related
1/ASD/
2/FGH/ASD
3/ZXC/ASD

I want to query the Folder table. If I select ASD as criteria , i want to filter all the folders that have a client that have ASD as "related". So for example, if i select ASD, i want to retrieve all the FGH and ZXC folders (i.e. "Bbbb", "Cccc" and "Eeee"). I dont know where to start with this. Any ideas?

Thanks!

 

[SOS]

Here's a sample that hopefully will show you what you need.

Also, I changed a few field names because NAME should not be used as that is an Access Reserved Word and an ultra sensitive one at that. Also, ID should be descriptive not just ID but FolderID or ClientID.

 

[rasco22862]

Thanks a lot!! I never thought that was that simple. Also thank you for your time building an example. Really.

 

[SOS]

No problem, glad we could help.