Omit unique values from a found set

[radiodan]

I am trying to omit all individual records (filtering on Name) from a found set of 4 produts, that have to be posted.

So that I am left with all customers who have purchased more than 1 product, allowing me to post them together.

I can get as far as a sorted list, but I have to wade through all the individual orders to find people who have purchased more than 1 product.

I know you can use a ! to find unique records, but only on the entire database.

Any suggestions for scripting this?

Thanks

Daniel

[Søren Dyhr]

Hi Daniel

Instead of trying to explain this in a language I hardly master, have I made a template for you, showing how I would deal with the matter. What I exploit here, is reporting and the new "Match Found Set" feature arriving with FM8's GTRR.

--sd

Invoicing.zip

[radiodan]

Soren,

Taken me ages to get my head round this but thanks to you your example I am finally there.