AnsweredAssumed Answered

Find AND not OR with additional find requests

Question asked by rollie on Jan 23, 2019
Latest reply on Jan 24, 2019 by rollie

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!?

Outcomes