I'm looking for duplicates in a number field, using "!" and constraining to the found set.

What it seems to be doing is finding duplicates in all the records and display those that coincide with the found set!

ie: in a set of 300 records (of 19,000)the "!" is finding, say 230 records when only about 10 are duplicates!

I've tried it 7 and 8 and get the same result.

The "!" duplicate search has always been problematic. When you use that search technique, Filemaker is simply looking at its index for the field in question, and the index reflects the entire file, not just the current found set.

So, you will have to use a script to find duplicates within the found set.

I've attached a file that gives a number of different methods that have been proposed in previous discussions on this forum. Some of them likely are not suitable for searching within a found set, but you can try them. Note, the "classic" method is the one that has appeared as an example script in the various incarnations of the Filemaker user manual over the years. It is simple and acceptably fast in most cases. There is another method included that is about twice as fast, but I can't remember if it's suitable for searching within a found set.

FindDupsVariations.fp7.zip

Since fm8 havn't searches in unstored been that big a deal, and since we deal with a found set could we make seaches in this unstored calcfield:

Exact ( aValue ; GetNthRecord ( aValue ; Get ( RecordNumber ) - 1) )

It will give different results due to the sortorder, or lack of. If say it's a few accounts you have searched for, and wish to have the last figure of each, then sort reversely, and issue a constrained find one the 1s (ones)

--sd