April 3, 200619 yr 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
April 3, 200619 yr 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
April 11, 200619 yr Author Soren, Taken me ages to get my head round this but thanks to you your example I am finally there.
Create an account or sign in to comment