- data entry form looking for possible previous entries when adding a
new one, possibly causing duplicates
I call it "soft duplicates" (ie: can't use "hard evidence" like a tax
file number or in this case, case number)
the idea is for the data entry operator to be flagged of a possible
match, shown the possibilities and clarify that with the new person
before the new record is saved (so they can throw it away and bring up
the previous record)
eg: where a possible soft duplicate for Kim Jong-il could be
Jong il Kim or
Kim Il-sung or
Kim Jong-suk
especially if they were at the same address, had the same date of
birth or some other factor was common between them.
I imagine it's the same sort of thing that Centerlink or the Tax
office would use to find fraudsters, although it doesn't have to be
that heavy-duty.
the best idea I can think of so far (last hour or so) is to extract
out the possible matching fields
- any name field to last name
- address
- date of birth
as a bunch of individual SQL statements using form fields triggered by
some form event (ie: onBlur of a field) to run an Ajax call to see if
a match. If so, return a message where another window displays the
possible matches for one being entered for the operator to choose.
... but is there a better way?
thanks
barry.b
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
