Mystery massive duplicates found in a database

Discussion created by liyangao on May 16, 2012
Latest reply on Aug 23, 2012 by rrrichie

In an old filemaker database developed a while ago, we found a 20+ repeated records each have the same number of duplicates. Since the duplicates are so uniform and the number of duplicates like 44, I am suspecting that those duplicates should not be generated manually and might be some systematic error.


Some background about the setting. The table which contains duplicates has participant visit info and multiple visits exist for each participant. A layout called follow-up contains identifiers for each participant and 15 columns of the visit form to facilicate the data entry for the multiple visits of each participant. Another layout contains the single visit form. I found that those duplicated records were not entered through the follow-up layout.


I can not fingure out what went wrong? If you have any insight about these mystery duplicates, please share your thoughts. Thanks a ton.