radiodan Posted April 3, 2006 Share Posted April 3, 2006 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 Link to comment Share on other sites More sharing options...
Søren Dyhr Posted April 3, 2006 Share Posted April 3, 2006 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 Link to comment Share on other sites More sharing options...
radiodan Posted April 11, 2006 Author Share Posted April 11, 2006 Soren, Taken me ages to get my head round this but thanks to you your example I am finally there. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6731 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now