Front Page databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a form in Front Page 2003 to submit results into a
database created in MS Access 2003. I need certain fields in the submission
form to be drop down boxes based on the same unique records in my database
(e.g. specific surgeons that I'm reporting on). I can get the database
connected and see its tables, but how do I get the drop down lists populated?
I've tried unsuccessfully through data access pages and I know the solution
is ASP, but the table to store results in is based off of three other tables
so I'm not sure it will work. Any ideas?
 
You will need to add your option fields in ASP
Take a look at http://asp101.com/samples/db_pulldown_linked.asp
--




| I'm trying to create a form in Front Page 2003 to submit results into a
| database created in MS Access 2003. I need certain fields in the submission
| form to be drop down boxes based on the same unique records in my database
| (e.g. specific surgeons that I'm reporting on). I can get the database
| connected and see its tables, but how do I get the drop down lists populated?
| I've tried unsuccessfully through data access pages and I know the solution
| is ASP, but the table to store results in is based off of three other tables
| so I'm not sure it will work. Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Submit form results to another form 2
Limitation in Number of Fields ... 1
results form input sent to another form 1
FP2003 - Receiving confirmation pages but database not updating 2
Creating a form in Front Page 1
FrontPage 2003 newbie needs database search form help 6
Database won't update 2
Database 1

Back
Top