How to create a dropdown form in FP 2003 that is populated with data in an Access 2003 table

[quinn_b]

I'm trying to create a dropdown form using an .ASP page in Front Page
2003. I would like this dropdown to display the items located in one
of my Access Database tables (assettype). Then when the form is saved
I want it to save the selection in a field in a separate table
(detailedrecords) of the same database.

How can I do this and thanks in advance!!!

I've tried creating a database connection and using the database
interface wizard connecting to the detailed records table, but it will
only save records to this table and will not use the relationship I
setup for the table for it's dropdown choices...

 

[Stefan B Rusynko]

If you are using the wizards see
http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp
and
http://spiderwebwoman.com/tutorials/picklist_with_dropdown.htm

On the results page use the form filed results to crate you query for the DIW
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| I'm trying to create a dropdown form using an .ASP page in Front Page
| 2003. I would like this dropdown to display the items located in one
| of my Access Database tables (assettype). Then when the form is saved
| I want it to save the selection in a field in a separate table
| (detailedrecords) of the same database.
|
| How can I do this and thanks in advance!!!
|
| I've tried creating a database connection and using the database
| interface wizard connecting to the detailed records table, but it will
| only save records to this table and will not use the relationship I
| setup for the table for it's dropdown choices...
|