Delete identical records

[weeznak308]

I have designed a database for use in research the purpose of which is to organize all of our past data. We have data in many different formats and I wanted to put it all together by importing it into a filemaker database. the problem is it is possible to have repeating data. I need a way to find and delete these extra records. If I do a search using rat id and date I should only get back one result since each rat only tests once a day. So how would I write a cleanup script that would search all rats and all dates and return repeats that can be deleted? Is this even possible?

Edited August 26, 2005 by Guest