rangebob Posted July 19, 2007 Share Posted July 19, 2007 I'm trying to create a script that will look at all of our records and omit any duplicates. I know that I need to loop through all of the records and look at the address field but I don't know how to set the omit to remove the duplicates. Thanks for your help. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted July 20, 2007 Share Posted July 20, 2007 Try this: http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000686 or http://www.kevinfrank.com/download/household-labels.zip --sd Link to comment Share on other sites More sharing options...
AudioFreak Posted July 20, 2007 Share Posted July 20, 2007 Also this one is pretty simple http://sixfriedrice.com/wp/deleting-duplicate-records-in-filemaker/ Link to comment Share on other sites More sharing options...
rangebob Posted July 20, 2007 Author Share Posted July 20, 2007 Thanks for the replys. I've looked at the three links provided, 2 are for FMP 7 and the other is to delete records. I only want to omit a duplicate address. I work for an elementary school and we want to be able to send letters home but want to omit brother/sisters from the file and only send one letter to the home. Thanks again. Link to comment Share on other sites More sharing options...
AudioFreak Posted July 20, 2007 Share Posted July 20, 2007 ok in the link I provided why not just change the script step Delete Record/Request [ No Dialog ] to Omit Record. Michael Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6117 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