Front Page - Multiple DRW on one page

Author

Multiple DRW on one page

Tom Brophy

2004-09-29, 7:17 pm

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

2004-09-29, 7:17 pm

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)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Tom Brophy" <TomBrophy@discussions.microsoft.com> wrote in message
news:FFA83BEB-2EBA-4D52-8666-ECAC999153D5@microsoft.com...
> 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
>

Paul m

2004-09-29, 7:18 pm

Hi
This might be of interest
http://www.spiderwebwoman.com/tutor...bledropdown.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
>page 1.
>
>--
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>==============================================
>To assist you in getting the best answers for FrontPage
support see:
>http://www.net-sites.com/sitebuilder/newsgroups.asp
>
>"Tom Brophy" <TomBrophy@discussions.microsoft.com> wrote
in message
>news:FFA83BEB-2EBA-4D52-8666-
ECAC999153D5@microsoft.com...
view information from[color=darkred]
cars (make, model, year,[color=darkred]
gets 'distinct' makes[color=darkred]
allow the user to click[color=darkred]
they click the item, I[color=darkred]
Models associated with[color=darkred]
the years associated[color=darkred]
year, I want to show the[color=darkred]
etc). I'm would prefer to[color=darkred]
>
>
>.
>

Tom Brophy

2004-09-29, 7:18 pm

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

"Thomas A. Rowe" wrote:

> 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)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Tom Brophy" <TomBrophy@discussions.microsoft.com> wrote in message
> news:FFA83BEB-2EBA-4D52-8666-ECAC999153D5@microsoft.com...
>
>
>

Kathleen Anderson [MVP - FrontPage]

2004-09-30, 12:14 pm

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/

Tom Brophy <TomBrophy@discussions.microsoft.com> wrote:[color=darkred]
> 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
>
>
> "Thomas A. Rowe" wrote:
>