Drop Down Box

  • Thread starter Thread starter Shona
  • Start date Start date
S

Shona

Is it possible to have a dropdown box that if one name is selected when
submit is selected then it goes to the database and when another name is
selected it opens up another file in this case and Excel File?

Cheers Shona
 
You would have to code the dropdown menu with the specific link for each
item in the dropdown.

--

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

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Thanks but I thought I had done that

<!--webbot bot="Validation" b-disallow-first-item="TRUE" --><select
name="Boilers" onChange="MM_jumpMenu('parent',this,1)" size="1">
<option selected value="Boilers">Boilers</option>
<option
value="#">-----------------------------------------------------------------<
/option>
<option value="url/File.xls">Order Form</option>
<option value="Blaupunkt">Blaupunkt</option>
</select>

The excel file opens fine but if I select Blaupunkt it takes me to a page
saying The page cannot be found.
 
Boilers and Blaupunkt are missing the file extensions, i.e., .asp, .htm,
etc. so the browser can not locate the page. If you are trying to do a
database lookup, then you have create a page to past the value to, and then
create the link as:

lookup.asp?i=Boilers

--

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

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Hi I think you may have misunderstood me.

I have a drop down box on a form which will be submitted to a database but
also in this drop down box I want one of the names eg boilers to go to
another form, but none of the others

Thanks Shona

So if they select Blaunpunkt I don't want it to go to another page
 
You have to provide a page or a script functions for selection to post to.

You need to create a page that does a database lookup, as I indicated, then
all selection that need to go the database would pass a value to the lookup
page, and any selections that need to go to an actual page or file, you
would enter the specific link.

<option selected value="excelfile.xls">Excel</option>
<option selected value="lookup.asp?item=Boilers">Boilers</option>
<option selected value="lookup.asp?item=Blaupunkt">Blaupunkt</option>
<option selected value="pdffile.pdf">PDF</option>

With a script functions on the lookup page you could test for Boilers, and
then instead of doing a database look up redirect to another page or actual
file, etc.


--

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

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Thanks for this

I'm a bit puzzled though as the page I'm designing will submit to a database
not look up. Do I have to have another column in my database that lists the
products but then how would it submit to that field?

Anyway I think I'll just do another link for this one link to a file

Thanks anyway
Shona
 
Back
Top