Getting rid of Duplicate records automatically

[Happyhelen]

I have a list of companies and there are many duplicates. I didn't know it until I made a calc field called companyphone and in it I combines the phone and the company. Then in list view I can find where there are 2 or more and delete the duplicates automatically, I just wondered if anyone has scripted this to do this automatically. My duplicates are found in a field called "companyphone" . I have searched on here but can't find how to do this automatically for an entire file

Thanks

Helen

[comment]

I believe there are quite a few threads on this subject. Try this one, for example:

http://fmforums.com/forum/showtopic.php?tid/159484/