I have 2 related tables (1 =>many).
The main table contains Customer Data and the related table contains Categories (let's say, categories A, B, C...) So every customer can have 1 or multiple categories.
I also have a lay-out based on the main table, with a portal showing the related categories. So far so good.
What i'm trying to find is how to search those Customers who habe BOTH categories A and B at the same time in the related table. Using a second search reques doesn't do the job because you also get the Customers with only A or only B.