Muli Select : 'And' instead of 'Or'

[simonb2013]

As I'm only on day 2, I'm sure this is a 'stupid noob' question ... but anyway ....

Let's say my main table looks like this:

Basket	Fruit
Blue	Orange
Blue	Banana
Blue	Grapefruit
Green	Orange
Green	Pear
Yellow	Banana
Yellow	Pear
Yellow	Mango

Now what I need, is for a user to be able to find which Basket contains both a Banana and an Orange.

I can do this in a relational DB quite easily, but the structure & functionality of things in QV have me a little at a loss.

Would anyone be able to point me in the right direction ?

Any help muchly appreciated

[swuehl]

You can look into the And Mode list box, there is a chapter in the Help / reference manual about that.

[Siva_Sankar]

refer the attached example