Flag Duplicates Script

[elizabethb]

Hi -

I have what I hope is an easy question.

I want to flag duplicate records with an "X"

Here is the script:

Sort

Go to Record [first]

Loop

Set Field [global, unique id number]

Go to Record [next, exit after last]

If [unique id number = global]

Set Field [flag, "X"]

Else

Set Field [global, unique id number]

End If

End Loop

I've simplified the field names for clarity. Anyone know why it's not working?

Thank you.

[Ugo DI LUCA]

Go here and checks for AndyGaunt's demo for duplicates.

Does it all even in your case.

Ciao Andy.

[elizabethb]

Thanks very much! I ended up using something similar with the self-join relationship. Neat way of doing it.

[andygaunt]

Elizabeth --

Glad you liked it.

Ugo....thanks for the plug.