Populate drop down lists

[Guest]

Sorry to be so confused about this. But I'm using FP 2003, and MS access
2000. I am trying to set up 2 drop down boxes, the second to populate off
the first. Example, If the first drop down has a list of items, let's just
use these 3 "fruit", "vegitable", then I need to second drop down to say
"apples", "oranges" if fruit is selcted, or "carrots", "peas" if the second
is selected. I've several websites on how to do this but I'm confused.
Seems like there should be a "relatively" easy way to do this. Any help
would be greatly appreciated!!!

I have the forms created using the wizard with the submission for, results
page and update page and that all works great, except for these drop down
boxes.

Thanks,
Michelle

 

[Kathleen Anderson [MVP - FrontPage]]

How to filter a database query using two drop down lists....
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm

--

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

 

[Guest]

Hi Kathleen,
Thank you for responding. I referred to that link from another post you
had. However, I'd like to not have the user have to hit submit. The form as
a long list of fields for them to populate, so I'd like to have the first
drop down populate in the easiest way possible, then have the second
automatically populate once they've chosen the first. Is there a way to do
that without hitting Submit? I think either way I'm going to have the 2 and
3rd pages (drop2, drop3) is that correct?

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Michelle:
The first dropdown list is populated automatically from the database - for
that matter, so is the second. How would you expect them to make a selection
from the first list without using the Submit button?

--

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

 

[Guest]

In this example

http://www.plus2net.com/php_tutorial/dd.php?cat=1

after the user selects the first drop down, the second is automatically
popluated, the user doesn't click Submit until both are popluated. I want
the second drop down to do this, so that the user can fill in all of the
fields and click submit at the end. In the cars and models example, the user
has to click Submit after populating the first drop down.
Am I making any sense??

 

[Thomas A. Rowe]

Somewhere there is a JavaScript function that is loading into arrays all of the records for both
fields, and then using a JavaScript OnChange event to change the content of the dropdowns. This will
require custom JavaScript coding on your part as well as a knowledge of VBScript to initially load
the arrays from the database, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Guest]

I'm not sure there is hope for me on this one. I figured out how to do it;
however, it only works if the form is set to "Send to other..." and a
seperate form name is listed. I set up the form using the Database Results
Wizard so I can have a results page and Editor page. The form properties are
being sent to a database. Is there anyway to send to database and send to
form?

 

[Thomas A. Rowe]

It requires custom scripting.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Guest]

ok, does anyone know of a website that I can post this question, with the
scripts I have that may be able to help?

 

[Thomas A. Rowe]

Custom... requires that you (or hire someone) have to write the script to meet your specific needs,
which requires you to learn ASP/VBScript, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Guest]

Wow, Thomas, thank you for your sarcasm, I have to say that was most helpful.
Maybe not helpful in getting Frontpage to do what I want, but definitely
helpful in making the decision never to post here again.

I'll figure it out on my own.......thanks for your support.

 

[Thomas A. Rowe]

Sorry, but you either have to learn to write the custom script to do what you want or you have to
hire someone to write it for you to meet your requirements.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Guest]

I understood you the first time.

Sorry, but you either have to learn to write the custom script to do what you want or you have to
hire someone to write it for you to meet your requirements.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Thomas A. Rowe]

I was not being sarcastic.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================