Find

[Snake Plisskin]

I have a table with following fiels: accountname, product, quantities.

I need to find only those clients who ordered water AND coca cola together.

How do i proceed.

I always get those who ordered only water, only coca or both. But I only need those who bought both.

[IdealData]

Sounds like you are executing 2 find requests.

Use a single find request and in your "product" field enter

water coca cola

FMP will only find records that match all the entries

[flook]

Enter Find

in account name type "!"

in product type "water"

new request

In account name type "!"

in product type "coca cola"

sort by account name

[Snake Plisskin]

Hi,

When I enter ! i get the duplicates...i need only the clients who are buying both of my products.

eg:

smith

water 10l 25 euro

coca 20l 35 euro

johnson

water 5l 12,5 euro

coca 20l 35 euro

etc.

thanks for your advise.

cheers,

snake