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.

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

Does it all even in your case.

Ciao Andy.

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

Elizabeth --

Glad you liked it.

Ugo....thanks for the plug.