Dynamic dependent dropdownboxes in a form

Hi, there!
I have been working on this for some days, and I'm close to giving up at
the moment! I half-way there, but I can't figure out the last bit...
I need this:
A dynamic database-insert form where users can make their reviews of a
bands concerts. When the user chooses the city in the first dropdown in
the form, the second dropdownbox, "location", will change to show only
concertlocations in the chosen city, and the third dropdownbox,
"concert-date", will show only dates the band has played on the chosen
location.
(All concerts are in a database-table (concerts) in the database
concerts.mdb, while the reviews will be written in the table "reviews"
in the same database.)

I have made the form (it works as a simple insertform now, but because
it shows data for about a hundred concerts in a row, it's practically
unusable). I also know how to fill each dropdown dynamically, but I
haven't got a clue to how I can make the selectionboxes dependent of
eachother....

Can anybody give me a _small_ hint, or tell me if there is a tutorial on
how to do this somewhere on the web?

Thank you!

Knut B. Lindbjør

Hi yea,
Ok it is a commercial extension for dreamweaver but if your really in a
hurry it does what you want.

http://www.interaktonline.com/Products/Dreamweaver-Extensions/MXWidgets/Overview/

they also have great support there too.

twocan's







"knut b" <franstk (AT) hotmail (DOT) com> wrote

Hi, there!
I have been working on this for some days, and I'm close to giving up at
the moment! I half-way there, but I can't figure out the last bit...
I need this:
A dynamic database-insert form where users can make their reviews of a
bands concerts. When the user chooses the city in the first dropdown in
the form, the second dropdownbox, "location", will change to show only
concertlocations in the chosen city, and the third dropdownbox,
"concert-date", will show only dates the band has played on the chosen
location.
(All concerts are in a database-table (concerts) in the database
concerts.mdb, while the reviews will be written in the table "reviews" in
the same database.)

I have made the form (it works as a simple insertform now, but because it
shows data for about a hundred concerts in a row, it's practically
unusable). I also know how to fill each dropdown dynamically, but I
haven't got a clue to how I can make the selectionboxes dependent of
eachother....

Can anybody give me a _small_ hint, or tell me if there is a tutorial on
how to do this somewhere on the web?

Thank you!

Knut B. Lindbjør

twocan's wrote:

Ok it is a commercial extension for dreamweaver but if your really in a
hurry it does what you want.
http://www.interaktonline.com/Products/Dreamweaver-Extensions/MXWidgets/Overview/

Thanks for the link! It looks good, but I was looking for a hint on how
to do this myself, - not the extension way. Isn't there's a way to do
this using dreamweaver on its own, without expensive extensions?

KnB

http://www.15seconds.com/Issue/000831.htm



is asp any good


twocan's




"knut b" <franstk (AT) hotmail (DOT) com> wrote

twocan's wrote:
Ok it is a commercial extension for dreamweaver but if your really in a
hurry it does what you want.
http://www.interaktonline.com/Products/Dreamweaver-Extensions/MXWidgets/Overview/

Thanks for the link! It looks good, but I was looking for a hint on how to
do this myself, - not the extension way. Isn't there's a way to do this
using dreamweaver on its own, without expensive extensions?

KnB

twocan's wrote:

http://www.15seconds.com/Issue/000831.htm
is asp any good

Yeah!!!
Thank you very much... This looks good!

KnB

http://www.macromedia.com/support/ultradev/ts/documents/client_dynamic_listbox.htm
http://www.dmxzone.com/showDetail.asp?TypeId=25&NewsId=4519
http://www.kermy.com/Extensions/DynamicDDL.asp

"knut b" <franstk (AT) hotmail (DOT) com> wrote

twocan's wrote:
Ok it is a commercial extension for dreamweaver but if your really in a
hurry it does what you want.
http://www.interaktonline.com/Products/Dreamweaver-Extensions/MXWidgets/Overview/

Thanks for the link! It looks good, but I was looking for a hint on how to
do this myself, - not the extension way. Isn't there's a way to do this
using dreamweaver on its own, without expensive extensions?

KnB

Les Matthews wrote:

http://www.macromedia.com/support/ultradev/ts/documents/client_dynamic_listbox.htm
http://www.dmxzone.com/showDetail.asp?TypeId=25&NewsId=4519
http://www.kermy.com/Extensions/DynamicDDL.asp

Thank you Les! This helped me a lot!

KnB