dynamically update form from DB?

[sphinx3212000]

I have a basic form that is used to register for monthly events. Most of the form would not change with different event registrations with the exception of two option button sets where the user picks their entree and dessert and maybe some static content on the form for pricing info.

How would i set up the access table to hold the different event details and more importantly is there a basic template of ASP code that someone could give me that would extract this event info and modify my base form.....basically just changing those two fields as a user selects to register for different events

I have some familiarity with ASP in that i use it now to dump the submitted data to an access db. I just want a way to have a dynamically generated form to where i dont have to make 20 forms just for a few changes.

thanks

[gil davis]

Originally posted by sphinx3212000
How would i set up the access table to hold the different event details
Best practice would suggest that you create multiple tables to help prevent duplication of data. Find out what factors determine the differences. Is there a relationship between the location and the food? Is there a limited set of entrees and desserts? You might set up a table that has locations (address, etc), one that has events, one that has entrees and one that has desserts. Then, you link the tables together. If you do the tables right, it will make it easier for you to maintain.
is there a basic template of ASP code that someone could give me that would extract this event info and modify my base form
There are tutorials on http://www.wdvl.com/Authoring/ASP/ that help with the basics.