Did you sort your found records by "BuyerCode" so that the duplicate records are grouped by duplicate value?
Appreciate the fast response Phil. I performed the find "!" on "BuyerCode", viewed the Show Omitted Only from the Records menu, then sorted on "BuyerCode". Most appear to be correct but I can identify several which are not in the list.
Two things I can think of to check:
- Is your calcuation defined to return text or number? (sounds like it should be text).
- Any chance the duplicates that weren't found aren't really duplicates? Perhaps one of the felds has an invisible character in it such as a space or return and this is keeping the value of BuyerCode from being a duplicate like it appears to be.
Again, fast, thanks.
1. Defined as text.
2. Possible, but does not appear to be. When I review the missing from the full database, one of known missing, they all seem to identical. After sorting the full database on the BuyerCode, they all appear together as suspected.
Do you have another suggestion on accomplishing this task?
They might still sort together, you'd need to click into BuyerCode and see if the cursor can be located one or more spaces to the right of the last character or if the field pops out to show it has more than one line of text (if there's a return in the field.)
You could re-index all the fields involved to see if that makes a difference. You can re-index a single field by turning indexing off, then back on using Manage | Database | Fields.
You can also re-index all your fields by saving a clone of your database and then importing all your data from all your tables into the clone.
If you are using FileMaker 11, you can also use Advanced Recovery options: Copy file blocks as is, Rebuild Field Indexes/Now to rebuild all the indexes in your file. (Learned that one here in the forum from LaRetta.)