I am creating a form where I will need user input via list boxes.
The first box will have a generic list of entries. Based on the selection of this box, the second box should be populated with options from an Access Database. Finally, the third box should be dependent on both the combinations of both the first and second lists.
I found a jquery script that does something similar with mysql, but unfortunately, I'm only able to use a local MS Access Database on the server that I'm running this under.
Here's a site I was mimicking mine after:
http://remysharp.com/wp-content/uploads/2007/09/select-chain.phpThe problem I found with this is that I need to have one extra field in my database that will display a value after all three boxes are selected, AND I need to use an access database. The other problem I was having with the method above is if a name was the same in 2 submenus
The subsubmenu for both menus would only appear under the first submenu as it didn't know any better.
Can anyone help?
