The help file is a bit thin in its description of how to locate and delete
"excess" duplicate records.

Locating duplicate records is straight forward (!), but how does one go
about finding duplicate records in excess of the first instance of a record?
Once found, I assume a simple delete all records is appropriate, assuming
that only duplicate records are displayed.

Any help or pointers would be appreciated.

Thanks - Art

Actually, the online help is very helpful in this respect. Read the article
"Finding duplicate values using a self-join relationship" (a search on
"duplicate records" will find it). It will explain precisely what you need
to do to achieve your goal.

Bridget Eley

in article BB5EF188.52A21%artrussell (AT) mindspring (DOT) com, Art Russell at
artrussell (AT) mindspring (DOT) com wrote on 13/8/03 9:33 AM:

Art Russell wrote:

In FileMaker ver 5 and above from the Users Guide, chapter 10, section
13, titled Example of a Scriptmaker Script. In ver 4 it is chapter 5,
section 26. This walks you through setting up and scripting a method of
finding all duplicates. Also if you search for "finding duplicates" in
the knowledgebase at filemaker.com you will find two more techniques.
This should help. Best of luck.

Michael Myett