Linking Drop Downs in FrontPage based on SQL DB

[jmalm]

I have a table in SQL that Links our States with our Restaurants. I want to
create a dropdown box that queries the states, easy enough.. however when the
user selects a state, I want the next dropdown to display the results of only
those restaurants in those states.

I guess this is similiar to a chained dropdown box using a javascript.. but
I want this to link to a sql table

 

[Kathleen Anderson [MVP - FrontPage]]

Here's how to do that with the DBRW and Access; I'm not sure if it will work
with a SQL database:
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm

--

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