避免在不使用索引字段的情况下进行重复和“不重复" [英] Avoid duplication without using Indexed fields and 'no duplication'

问题描述

我正在寻找有关表单设计正确方法的建议，以提示用户输入数据以避免重复的记录.

I'm looking for advice as to the correct method for form design to prompt the user entering data to avoid duplicated records.

例如: 用户在firstName surName字段中输入配置文件信息 多个配置文件使用相同的名称是非常可能的(例如John Smith，因此无法避免使用索引字段来避免重复). 如果没有提示/警告用户不要输入相同的记录，则用户有可能两次输入相同的记录.

For example: The user enters profile information in the fields firstName surName Its highly possible for numerous profiles to have the same name (e.g John Smith, so indexing fields isn't possible to avoid duplicates). Its possible for the user to enter the same record twice if they are not prompt/warned not to do so.

什么是提示用户避免重复输入并强调记录可能"已经存在的最佳方法?

What is considered the best method to prompt users to avoid duplicate entries and highlight that a record 'may' already exist?

预先感谢您的任何建议.

Thanks in advance for any advice.

推荐答案

我在数据输入过程中对人员进行重复数据删除的方法是使用未绑定的表单，该表单收集必填字段，然后检查现有数据并显示可能的列表火柴，以火柴接近度的降序排列.我在名称和各种子字符串的名称上使用Soundex()和Soundex2()来确定等级.

My approach for de-duping people during data entry is to use an unbound form that collects the required fields, then checks the existing data and presents a list of possible matches, sorted in descending order of closeness of matches. I use Soundex() and Soundex2() on the names an various substrings for determining the rank.

以下是我的客户应用程序之一中的添加客户"表单示例:

Here's a sample Add Customer form from one of my client's apps:

左侧的点表示匹配程度，红色表示完全匹配(或近似精确-我不太记得确切的公式)，橙色表示接近匹配，然后是黄色表示绿色，表示非常遥远火柴.最接近的匹配项在列表的顶部.

The dots at the left show the level of match, with red for exact (or near-exact -- I can't quite recall the exact formula), orange for close match, then yellow and going to green for very remote matches. The closest matches are at the top of the list.

要点是，当单击ADD按钮时，在此处进行了重复检查，然后用户必须确定是否有任何可能的匹配项是真实的重复项，然后添加或不添加.

The point is that the duplicate checking is done here, when the ADD button is clicked, and then the user has to determine if any of the possible matches are a real duplicate, and then add or not.

换句话说，我依靠人类的智慧来避免创建重复项，但是如果愿意，他们可以创建重复项.但是我尽量避免这样做.

In other words, I depend on human intelligence to avoid creating duplicates, but they can create them if they want to. But I make it as easy as possible to avoid doing so.

这篇关于避免在不使用索引字段的情况下进行重复和“不重复"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！