I'm struggling with something which ought to be quite basic.
I have a customers table, and a related table for orders. On the customers record, I have a portal to view order records related to the customer, via a customer reference. Basic.
On the orders table there is a text field, product code.
We need to find customers that have ordered product A, B, C, D and E (they must have order all of these). As opposed to A, or B, or C, or D, or E, which would be accomplished using the new request, or extend found set.
How do I do this!?