I have a table that has two fields
ICDA Code A6 //International Classification of Diseases, Adapted for use in the US
Description A25
I would like to have a lookup or picker or some other control where the user can key in either the ICDA Code or some portion of the Description and have it return either the one record that matches or a pick list of the records that match. Example: the user keys in 'Diabetes' and it would return a pick list with at least these two records
25000 Diabetes Adult Onset
25001 Juvenile Onset Diabetes
or the user keys in '2500' (short one digit) and it would return the same two records...
Sometimes you get the code and sometimes you get the description and rather than make the user pick from two different controls or two different buttons or whatever, we know it is a code or description. BTW the codes are not always a number. We store the ICDA Code in the claim records not the description for obvious reasons.
Another example where I use this is a lookup for insurance companies, there hundreds of Blue Cross and Blue Shield claim mailing addresses. So, I usually have one field and let the user key in EITHER some portion of the name OR some portion of the address. Usually they are PO Boxes or Street addresses so if the user keys in just the numberic part of the street address we can get a quick hit on the insurance company they are looking for! And they don't have to look at thirty Blue Shields to find the address that matches the patient's insurance card.
Hope I made myself clear
Thanx in advance
Dave