search forms & structure

[jaycie]

I have been trying to create a form for searching through my product table. I wanted the user be able to choose whether he/she wants to limit the search by selecting spefic categories. So far, I created that kind of search with query tables and then the search result is displayed as a query table. Right now I have a query table for each kind of search: like one for more general search, another where the all the items searched are limited by category, and etc.

However, I want to be able to have the user search and view a summary list. And then when the user double clicks on the item then a more detailed screen will appear. I am having trouble doind this. I tried making additional forms for search result and then another form for detail information.

Am I approaching this right? Or am I doing a lot of unneccessary work.

Please help!!

 

[Fizzio]

Rather than displaying tables (as you seem to be), use forms. Use comboboxes/ textboxes to populate the search query then display them (on the same form if you want) in a listbox. You can then use the double_click on the listbox to open a new form with the specific details. Hope this makes sense.