Hi all Experts!
I need URGENTLY to build a search/select page using 4 dependent list boxes or drop down menus. Client-side is not an option because the size of the data (up to 6,000 records and almost 1 MB).
The idea is to have this 4 drop down menus displaying a "Make your selection..." message and refresh (requery) the 2nd list box when a selection is made in the first list. Then the values in the 3rd list box are refresh depending on the selection made in the 2nd list box and so on. Finally, when a selection is made on the 4rd list box diferent values will be shown (lets say on a table) for the user to choose (click) one of them. Upon selection a "detail" or "process" page is shown.
For exmple:
First list box.- Manufacturer (Chrysler, Ford, Honda, etc). This can be static.
Second list box.- Year (From 1998 to 2004. However not all Manifacturers have cars for all the years and the idea is to display ONLY the years available for the selected manufacturer).
Third list box.- Model (Displays the diferents models available forthe selected manufacturer/year).
Fourth lis box.- Submodel (Displays the diferents models available forthe selected manufacturer/year
Values to show on table.- Up to 5 diferent Insurance plans cost
When a plan is selected (clicked) a new page shows up displaying detailed information for that plan and a form for the user to type his/her personal and car information.
Now, the data is coming from one single table, and it look something like this:
ID Manufacturer Year Model Submodel PlanA-Price PriceB-Price ... PlanE-Price
0001 Chrysler 1998 ModelA SubmodelA1 0.00 0.00 0.00
0002 Chrysler 1998 ModelA SubmodelA2 0.00 0.00 0.00
0003 Chrysler 1998 ModelA SubmodelA3 0.00 0.00 0.00
0004 Chrysler 1998 ModelB SubmodelB1 0.00 0.00 0.00
0005 Chrysler 1998 ModelB SubmodelB2 0.00 0.00 0.00
0006 Chrysler 1998 ModelC SubmodelC1 0.00 0.00 0.00
0007 Chrysler 1998 ModelC SubmodelC2 0.00 0.00 0.00
0008 Chrysler 1998 ModelC SubmodelC3 0.00 0.00 0.00
0009 Chrysler 1998 ModelC SubmodelC4 0.00 0.00 0.00
0010 Ford 1998 ModelD SubmodelD1 0.00 0.00 0.00
0011 Ford 1998 ModelD SubmodelD2 0.00 0.00 0.00
0012 Ford 1998 ModelE SubmodelE1 0.00 0.00 0.00
0012 Ford 1998 ModelF SubmodelF1 0.00 0.00 0.00
0012 Ford 1998 ModelF SubmodelF2 0.00 0.00 0.00
And so on for each Manufacturer from 1998 to 2004.
My intention is to have a html page looking something like this:
--------------------------
----------
----------
----------
----------
----------
----------
----------
----
Drop-down Menu1 Dp-dwn Menu2 Dp-dwn Menu3 Dp-dwn Menu4
Manufacturer Year Model Submodel
--------------------------
----------
----------
----------
----------
----------
----------
----------
----
DISPLAY SUBMODEL SELECTED
Plan A.- Display price A for Selected submodel A dateiled page is shown
Plan B.- Display price B for Selected submodel <== for each price when cliked.
Plan C.- Display price C for Selected submodel
--------------------------
----------
----------
----------
----------
----------
----------
----------
----
Could you PLEASE help me with this?
In advance thanks a lot
Best regards
