duplicates within a found set

[tomp]

I need to find all records with duplicated values of a field within a found set.

When I use the '!' value and 'constrain' the found set, FM applies the '!' on the entire set of records, not just on those records in the found set. So I get a much larger set of records than I expect.And records that do not meet the criteria I was hoping for.

How does one find duplicated values of a field within a found set?

TIA

[comment]

See:

http://fmforums.com/forum/showpost.php?post/305942/

[tomp]

Thanks.

That's kind of what I thought.

I solved the issue by creating a calculation field and then searching for duplicates on it.