Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Menu question

Status
Not open for further replies.

Sponge

MIS
Oct 15, 2000
16
GB
Can a menu drop down list be made to lookup values in a database instead of having to input the list values manually??

Any Help will be mucho appreciated.
 
Hi Sponge,

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.

Hope this helps! Nick (Web Designer)


nick@retrographics.co.uk
 
Short answer YES

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top