thedart
05-25-2001, 12:34 PM
What do I do to be able to enter characters from the middle of a record string and have the look up function find and or suggest the record?
Example: The record is "#1054 Baptist Hospital"
The LOOKUP function will only work if you enter "#1054" and then it will suggest "#1054 Baptist".
But I want to be able to enter "Baptist" and have it find the record. In other words, I want to be able to enter "Baptist" and have it find the first 5 characters which are the customer number.
Example: The record is "#1054 Baptist Hospital"
The LOOKUP function will only work if you enter "#1054" and then it will suggest "#1054 Baptist".
But I want to be able to enter "Baptist" and have it find the record. In other words, I want to be able to enter "Baptist" and have it find the first 5 characters which are the customer number.