I need a page that may or may not be passed parameters but includes up to five list boxes. Beginning with the first parameter, the data needs to be validated against the attached database (MS Access). If found, the value is placed in the list box text field, the list box is activated, and the next criterion is evaluated. If not found, that list box is populated with the data returned by a SQL statement and all subsequent list boxes are deactivated. Each valid item is also stored in a session variable - session("vmake"), session("vmodel"), etc.
For example:
No parameters are passed, so the first list box (Make) is populated with the unique vehicle makes - Ford, Chevrolet, GMX, Chrysler, etc. from the table in the database.
However, when a Make parameter is passed, the datum is evaluated against the database and if found to exist, the Make list box is populated with all available Makes but the Models list box is populated only with the unique models for that select make. Similarly, each subsequent list box is populated with only those items which are subsets of the previous list boxes data.
When only some or no data is passed, the list boxes are populated with items from the table so long as a match occurs. When no further match is possible, the available items are included in the next list box. With an On_Change event, the table is searched for the unique items which correspond to the items selected in the list boxes above and that list box is populated with those items.
One last item of note. This page MUST run on Windows servers and interface with the MS Access database via either ODBC or DSN.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows Server is the platform. Must work with IE6, Netscape 8, and FireFox.