The criteria for judging a record a duplicate in ebase is tighter
than just the name. Name alone is really not a useful criterion,
since so many people have the same name.
There are several possible criteria in ebase, the most common being
Tight and Loose. Tight insists that first name, last name, the number
part of the street address and the zip code be identical. Loose just
uses last name, the number part of the street address, and zip code
(which would of course flag family members with the same last name as
dupes). The big red Y uses the Loose criterion.
It would certainly be possible to define a new dupe criterion using
only the name and adjust the calculation that generates the big red Y
to flag it. A couple of cautions. First, the Y would be generated
only after a new record was created and the name typed. If the Y
appeared, the new record would need to be deleted, and you'd then
have to find the existing record. Second, the name would have to be
entered exactly the same as the existing record for the dupe to show
up (as was certainly the case with your previous system). It wouldn't
show up Dave Shaw as a dupe if I was already in the file as David
Shaw.
Look at the fields Dupecheck Tight and DupeCheck Loose to get an idea
of how to do this. The calculated field Data Entry Duplicate?
generates the red Y based on the DupeCheck criterion.
>Hi, folks. Our data-entry volunteers have expressed frustration that ebase
>doesn't automatically check for duplicate names during data entry the way
>our old (Paradox) database did. In other words, rather than first doing a
>Find to see if the name exists, they'd like to just start entering the
>record and have ebase notify them if a duplicate already exists. Have any
>of you implemented such a feature?
>
>Could it be as simple as redefining the dupe check that puts a Y in the
>dupe? field, and if so, how would I go about doing that and making it run
>automatically when leaving the name fields?
>
>Thank you,
>Ben Stallings
>World Population Balance
>
>
>
>------------------
>Reminder to each recipient: To change your list account preferences, go to
>http://email.sparklist.com/scripts/lyris.pl?enter=support and enter
>the email address you used to subscribe to the ebase support list::
>[EMAIL PROTECTED]
>
>To unsubscribe send a blank email to [EMAIL PROTECTED]
>---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
>---------------------------------------------------------------------
--
Dave Shaw Northwest Classics, Inc
tel: 206-954-7526 fax: 206-625-1338
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
