Comparing the same field in 2 records, delete the duplicate

[GarrettC]

Thought this would be easy, so humbling...

I thought this would be a basic loop through records, looking at the last record/specific field and comparing it to the current record/field and if they match, delete the current record.

The problem is the comparison, when I am on the current record in the loop, how do I compare with the same field from the last record? I see no GetLastRecordField function.

The final idea is to have only unique record entries in my field of choice.

As always, thanks in advance.

Edited April 11, 2008 by Guest

[Fitch]

If you search this site you'll find dozens of threads about this topic. You'll also find relevant results at www.filemaker.com/kb/

Essentially, you need to store the value of the current record before you move to the next record. With FileMaker 8+ we can use a variable but your profile says FM7 so use a global field.

[Søren Dyhr]

The way that algorithmic comes closest to you description must be this:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000669

Where the comparison, quite Luca di Pacioli'ish, only takes the record just above into consideration.

--sd