Rick Cogley 7/2/2010 12:48:53 AM
This would be wonderful to have. Re your questions:
* How would you want to specify the criteria for determining a duplicate?
=> Either full record, or, selected fields.
* What action would you want to accomplish upon duplicate identification?
=> Either take invasive action as in - Delete one, or merge them. Or, add a field like Duplicates and mark that field up with information so we can see what is a duplicate of what.
* Would you want the dupe to be merged automatically (similar as simultaneous record editing do), or just a message?
=> I would like the option to merge automatically, but I think it depends upon the record set, and, if I choose not to merge, I would like some field to show the info about the dupes. (by the way, the simultaneous editing warning is the cat's meow - very cool!)
* Would that vary by how the record was entered (manual, web to record, API, etc.)?
=> yes, I think it would have to vary by how the record was entered, if you mean to give a message right away. Non-interactive, it would be good to have some marker so the dupe could be seen and weeded out later.