[AccessD] Re: "fuzzy logic" search

Susan Harkins ssharkins at bellsouth.net
Wed Oct 22 10:47:28 CDT 2003


Arthur has a context-sensitive combo box control  too -- might be good in
this situation as well.

Susan H.


> John,
>
> If you break the SSN up into its 3-2-4 components,
> it would make it a bit easier to do a compare.
> I also assume that you would be using a mask
> to prevent anything but numbers in it.
>
> The real way of "fixing" it would be to have a table
> of claimants and make them select them from a list.
>
> I just did something similar with an ADP to get around
> the number of records they would have in a combobox.
>
> Give them 2 text boxes at the bottom of a "select" form
> where they would enter the first 3 characters of the
> last name and the first 3 of the SSN.  Then limit
> the display to those that match and give them a "select"
> button to grab the one they want to use.  I had the
> select form pop up when I entered the field I wanted
> to grab the data for.
>
> Robert
>
> At 07:36 PM 10/21/2003 -0500, you wrote:
> >Date: Tue, 21 Oct 2003 20:05:43 -0400
> >From: "John Colby" <jcolby at colbyconsulting.com>
> >Subject: [AccessD] "fuzzy logic" search
> >To: "AccessD" <AccessD at databaseadvisors.com>
> >Message-ID: <DCEFJAOENMNENLAAOFGPGEHKFGAA.jcolby at colbyconsulting.com>
> >Content-Type: text/plain;       charset="iso-8859-1"
> >
> >My client is having difficulties where the data input people are entering
> >duplicate claims because wrong names or SSNs are entered.  He's asked how
> >difficult it would be to do a search for the names entered (seems
irrelevant
> >if it is wrong) but then has asked how difficult it would be to do a
"fuzzy
> >logic" search for SSNs that are different by up to 2 characters.  I don't
> >even have a clue how to attack something like that.  Any ideas (other
than
> >"out the door, no parachute")?
> >
> >John W. Colby
> >www.colbyconsulting.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list