Multiple DRW on one page

[Guest]

I am trying to create a page that will allow users to view information from
an excel spreadsheet that contains information about cars (make, model, year,
and other information). I have a drop down list that gets 'distinct' makes
(Ford, Toyota, etc.) from the spreadsheet. I want to allow the user to click
on an item in the drop-down box (e.x. Ford). When they click the item, I
want to display the next drop down box that shows the Models associated with
the Make. When they click the Model, I want to show the years associated
with the Make and Model. Then when they click the year, I want to show the
table of information (part numbers, description, etc). I'm would prefer to
do as much as possible on the same page if possible.

Any help would be appreciated.

Tom

 

[Thomas A. Rowe]

1. You should move this content to an Access database.

2. You can't do this on the same page without create custom JavaScript Arrays to load all of the
selection into the Make, Model, Year dropdowns on page load. Also this can cause a timeout for the
user if you have lots of Makes, Models and Year content.

3. If is easier and faster to make a selection in Make dropdown on page 1, then post the selection
to page 2, and population Model dropdown from the database based on result of the Make selection on
page 1.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Paul m]

Hi
This might be of interest
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm

-----Original Message-----
1. You should move this content to an Access database.

2. You can't do this on the same page without create

custom JavaScript Arrays to load all of the

selection into the Make, Model, Year dropdowns on page

load. Also this can cause a timeout for the

user if you have lots of Makes, Models and Year content.

3. If is easier and faster to make a selection in Make

dropdown on page 1, then post the selection

to page 2, and population Model dropdown from the

database based on result of the Make selection on

 

[Guest]

Thanks for the reply. I wish I could move it to Access but I believe the
spreadsheet is also used for other purposes. I figured I might have to go to
multiple pages. I have already populated the Make drop-down list. How can I
get to the next page/search when the user clicks on one of the selections?
and how should I take the make to the next page for the next query?

Thanks,

Tom

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Tom:
You could import the spreadsheet into Access and create a database.

Open Access, click on File | Open, choose Files of Type - Microsoft Excel
(*.xls), and pick your Excel File. A wizard will start that will help you
convert your data.


--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/