I have to design a search using asp.
I am using an html page with the form named search.html
One result page named result.asp for displaying the search result.
One main.mdb file with two tables(a and b) for the two items in the 

main menu.
Search Details / Criteria 
Items on the html page.
I have a 2 list/menu's 
1.main menu (name=menu1)
2.sub menu   (name=menu2)
The main menu has 2 items.
The submenu has many items.
One Submit button.
Criteria
The user must select one item from the main menu, then the user must 

select an subitem from the submenu.
Depending on what the users click iam supposed to display the result 

in the result.asp page.
(ie)
If the user selects item a from main menu and selects some x/y from 

submenu the result page should display fields from the table a of the 

main.mdb
or
If the user selects item b from main menu and selects some x/y from 

submenu the result page should display fields from the table b of the 

main.mdb
This result should be displayed in on the result.asp page depending on 

the menu item and the submenu item the user clicks. 
How iam i supposed to do this should I use some kind of a looping 

structure for requesting the form items (ie menu/submenus) and to 

display the table depending on the items selected.
regards
Ashwanth 

__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com