JohnW Posted March 7, 2001 Share Posted March 7, 2001 I have FMPro 4.1 on my office PC that runs a simple single file/single screen DB. Due to some file merging I have some number of duplicate records. Each record has a "work order" number. I want to have a search that finds all the duplicates so I can kill the older version. How is that done ? JohnW Link to comment Share on other sites More sharing options...
Vaughan Posted March 7, 2001 Share Posted March 7, 2001 Change into find mode. On the status bar there is a pop-down list or menu with symbols: select ! to search for duplicates. Note that this finds all duplicates -- that is, if two records have the same value it finds *both* of them. So don't delete them all, scroll through and delete the extras. Link to comment Share on other sites More sharing options...
JohnW Posted March 9, 2001 Author Share Posted March 9, 2001 Thanks, I'll give that a try . JohnW Link to comment Share on other sites More sharing options...
Arin Posted April 27, 2001 Share Posted April 27, 2001 Is there a script command for the "!" function? -a Link to comment Share on other sites More sharing options...
BobWeaver Posted April 29, 2001 Share Posted April 29, 2001 Enter Find Mode [no restore] Set field [theField, "!"] Perform Find [no restore] Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8369 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