Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can look into the And Mode list box, there is a chapter in the Help / reference manual about that.
refer the attached example