Drop down form fields and SQL

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Free FrontPage Templates

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Drop down form fields and SQL

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Drop down form fields and SQL

Page: [1]


Welby Posts: 59 Joined: 11/12/2002 Status: offline	Drop down form fields and SQL - 11/13/2002 13:25:23 Is there anyway to use a Frontpage form to access multiple tables in a DB with drop downs? For Example - I have an Employee_table, a Location_Table, and a CODE table. I want to create a form, with drop downs that access those 3 tables. So, when a user goes to fill in the form, they can hit a drop down arrow, and get a list of all employees, choose their name, and do the same for Location, as well as the CODE. If anyone can help - or point me in the right direction, I would greatly appreciate it. Sincerely - Welby


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Drop down form fields and SQL - 11/13/2002 23:23:39 You can do a basic query / output for each table eg : <form> <database query> <Selectbox> </database query> <database query> <Selectbox> </database query> <database query> <Selectbox> </database query> </form> However, it can be database intensive (ESPECIALLY using the DRW) For data that doesnt change too often, I would recommend this : http://www.learnasp.com/learn/speedappdata.asp _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to Welby)