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, 200817 yr by Guest

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.

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