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.

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

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

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