Im not sure of the details, but I would imagine the easiest way to go about this would be to use a mixture of ASP and javascript. You could use ASP to read the information from the database, and assign the different values to variables. Then use a javascript based drop down menu and input these variable names as the list items.. Even simpler would be to use a text file on the server which holds the values instead of a database but this may not be viable if your database is very complex.
Long answer Yes but I would upgrade to Dreamweaver Ultradev where many of these type of things are dealt with.
You need to open a connection to the database create a recordset of the values you require then assign them dynamicaly to the dropdown menu Live long and make your kids suffer..
Thanks for the replies firstly. A data source for the database has been created, unfortunately i cannot upgrade to Dreamweaver Ultradev also.
The database table from which the menu will get its values from is for shipping companies, which will be added to frequently, so not only do i want to pick from the menu list but also be allowed to enter a new shipping company when required.
Just a quick note, this is the first time i have done access work for an intranet site, normally we install access on a users pc.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.