Hi,

I have a portal in a form on my Customers table linked to an Order Items table, which shows all the products each customer has ordered. Each Order Item record contains the product name, units, sale price, currency. It's fine searching for customers who have bought a specific product, but I wish to search for customers who have ordered (both of) 2 specific products.

Is there an operator I can use in the search term to do this? or is there a way of including repetitions of non-repeating fields within a portal in find mode? or another solution?

Thanks in advance for any help

wish to search for customers who have ordered (both of) 2 specific products.

It's called an AND search, download this Archive ...there in the Bonus folder is another folder called ANDFIND

open it and drag both files onto you filemaker icon in the dock, and let the conversion take place.

To prevent people downloading something they already have, could I tell that it's Jon Rosens template from Iso ezine 18 ..from way back when files were in .fp3 format.

--sd

Thanks S

I can't get it to work (not even in the example you attached

Did you migrate it as I descriped, it works here - One thing though is that it uses two files as we did pre 7.0 which could be quite confusing. But the isse here is that the maintable with the portal has yet another layout for seaching, where all repetitions of the related record sans portal are show, when the portal is missing could only one occurance be shown. In the normal layout with the portal is only first repetition shown, not revealing that it's a repeating field.

Try to experiment with it a little, and if you still can't get it working ...would I then transform the template to a more genuine seven'ish thingy...

--sd