I have a file which I use to create an index of articles. Each record in
the index file contains the article unique number. the article name, and
the index word. Each article may have one or more index terms.

I have a script that does a find based on one or more index term. The
found set may contain any number of articles and frequently contains a
single article many times.

What I want to do create a subset of the found records that eliminates
all the duplicates. Obviously, I don't want to delete the duplicates -
just remove them from the subset.

I can do it by sorting the found records by article number, going
through all the records comparing them one at a time to the previous
record and marking those that are duplicates. This system works but
seems cumbersome.

Is there are way to do a simple duplicates find and then unselect the
duplicate records?

Thanks,

Rich

The Filemaker help file does a great job of explaining how to identify
duplicates using a self-join relationship. Follow those instructions,
do your find, then Constrain Found Set (Omit 'Duplicate').

You could do a straight find with 'Unique' as a criteria, but because
you're searching a calc field that references a related table, the
Constrain will be faster.

G

Rich Sagall wrote: