Are you doing ths by hand or in a script? If you are using a script, can you get what you want by entering find mode, then entering the criteria? (That clues us in that there's a script problem).
If you can't get this to work with a manual find, what is the structure of your database? One table, Two related tables or ?
If more than one table is involved, in which fields from which tables are you entering the two values? How are the tables related? and on what layout are you performing the find?
By hand. It's a one-time situation. I'm going to program in the future to prevent duplicates at all.
The database has many tables, but I'm searching on a layout that's based on the table in question. Consequently, I'm not searching through a relationship.
Layout based on table: History Fields: History::SerNumContact and History::SerNumEvent
That suggests that either there are no records for the event ID that have duplicate contact IDs (maybe you have duplicate contact records with different contact IDs) or you have a misbehaving index on one or more of the fields involved.
You can rebuild the index to a single filed by using Manage | Database | Fields to turn this feature off then back on. You can rebuild all the indexes in your file by importing all your data into a clone of the file, or if you have FileMaker 11, you can use Recover with only the following advanced options selected to rebuild your file (Thanks to LaRetta for teaching me this last trick).
Copy File Blocks as is
Rebuild Field Indexes Now
If there are no records, then the find should find none, not 144.
Thanks for the other tip.
Good point. I know this may be obvious, but it never pays to assume stuff, did you sort your records after the find so that records with duplicate values will be grouped together?
That's the step I was trying to avoid; LOL.
But if you don't sort your records, how could you be sure you've spotted all the duplicates for a given value--especially with more than a hundred records?
BTW, another way to seach for duplicate values is to use a self join that matches on the fields where you have duplicate values. It's more work to set up--especially if this is a one time fix.