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.
Thanks to all.

Bob Lambert