Drop down boxes

[Chris van den Heever]

Hi,thanks for all the great material which is posted in this group.
I was wondering if anybody could help with this question
I would like to have two drop down boxes A and B
The main selection is in A and a Sub category is in B
If a selection has been made from A it must then repopulate the correct
fields in B
for the related sub category to be selected
Is this possible?

Thanks.

Chris.

 

[Jim Buyens]

-----Original Message-----

Hi
Howdy.

Thanks for all the great material which is posted in
this group.
I was wondering if anybody could help with this question
I would like to have two drop down boxes A and B
The main selection is in A and a Sub category is in B
If a selection has been made from A it must then
repopulate the correct fields in B
for the related sub category to be selected
Is this possible?

You can't do this with FrontPage only.

In the most common case, where both drop down boxes
contain choices based on a database table, you would need
to code this in a combination of JavaScript and ASP,
ASP.NET, or some other server-side programming
environment.

The portion you would develop in JavaScript responds to
the onChange event of the first text box, sets a hidden
form field or some either to indicator to indicate the
reason for a form submission, and then submits the form.

ASP or ASP.NET code on the Web server queries the hidden
form field to determine the reason for the form
submission, decides that it needs to reload the second
list box, and then regenerates the form with new values
in the second list box.

(This is decidedly less work in ASP.NET, BTW.)

If the number of variations in both text boxes is small,
you can also do this in JavaScript only. This requires
fewer interactions with the server, but more data
transmitted to the browser.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Kathleen Anderson [MVP - FP]]

Hi Chris:
If your data is in an Access database, you can do this with the FrontPage
Database Wizard: How to filter a database query using two drop down
lists....
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm

 

[Jim Buyens]

Hi Chris:
If your data is in an Access database, you can do this with the FrontPage
Database Wizard: How to filter a database query using two drop down
lists....
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm

Yes, but this requries that the drop-down lists be on different, successive pages.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------