>I have a customer table with name, address, etc. fields along with contact name, phone # etc.
>There is a need to be able to locate a customer via anyone of these fields. What is the best approach
>to accomplish this task ???? Surely this is not a unique situation.
>All ideas will be welcome.
I would suggest you build a pick list class which will allow the user to change order at any time and to have a field to allow them to enter a value for the search. Then, from that pick list, you can then fire a data entry window for the located record.