Hello all, I'm looking for suggestions on how to create a search function within my application. First I'll give you an overview. At the top of my page I have a form that contains name and date fields. When a user puts in some data and selects "Search" a simple column of results will be displayed on the left side of the screen. Example: User searchs for a date of "09/22/08" and a name of "Customers." In the left column a list of all customers for that day will be generated. There is A LOT of detail associated with these customer results therefore all data such as name, address, zip code, order number etc is not pulled from the database upon initial search. Instead, if a user clicks a customer name a seperate query will run and retrieve all of the pertinent data and provide a bulleted list under the customer name. What my vendor wants me to do is provide a way for someone to search through all the customers including the details that I do not initially display to allow them to find specific data. Such as finiding a record with a specific zip code. They then want to be able to click next to go to each consecutive record with that zip code. Any ideas on how to do this since all that data is not initially pulled in?
