deleting duplicates - but leaving one

[davepain]

Hi ,i want to write a script that deletes all duplicate records (duplicate by one field) the other fields do not matter, however i want to leave one of the records from the duplicate set, whats the easyest way of doing this?

Thanks

[EddyB]

Hi

Have a look at this post... this will do it it

http://www.fmforums.com/threads/showthreaded.php?Cat=&Board=UBB16&Number=55071&page=&view=&sb=5&o=&vc=1

Ed