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?
 
Back
Top