You may be familiar with the routine when you have multiple duplicate records in your database. You end up having to reference multiple sources. Which can be a real pain. Ultimately, you end up needing to decide which record is the master and then merging as much of the data as possible from any of the duplicates.
This is a common scenario with any multi-user database system. Where, anytime you have more than one person working on the same data, you can inevitably end up with duplicates.
There are a few ways to deal with duplicates. The first is to try to prevent them in the first place. While this is certainly possible, there are other times where routine imports come from external sources or you've simply allowed duplicates to be entered into the database.
The question now is, "How do you identify duplicates?" and how do you address the fact that our eyes can trick us when we're looking at data which appears exactly the same – yet it's not. This video will show you how to truly approach duplicates and how to deal with them by giving you full control over defining what determines a duplicate or not.
Click the title or link to this article to view the video.
Source: FileMaker Magazine