>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
Search window, using SQL u search via criteria, the user gives you. Show the results in a grid.
Alesh