Front Page databases

M

Marc

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?
 
S

Stefan B Rusynko

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