I'm trying to set up templates to create pages like this one from a db: http://www.attachmentcenter.org/conferences/houston2002.htm.
The hard part is that the number of days in a workshop is not always the same. Therefore, the section where I need to create days & sessions varies.
I don't want to make a db that has say like 10 or 20 repeated fields like, day1, agenda1, day2, agenda2, day3, agenda3, etc. But the db has to have the ability to have unlimited number of days for each workshop.
I figured the thing to do is to use two tables. one with the event name, location, description, etc. one with agenda information for each event. There would have to be an identifier for each table, perhaps event_id.
Here, finally, question number 1:
How can i create an input form that when submited automatically fills in the event_id on the next table.
Next, after I do that, how can I submit information to the second form over and over and over again until i have all the days and sessions input with the event_id carrying over to the event_id field in the agenda table each time.
Question 2:
While I'm doing all that, I need to create a unique url based on event_id that is also automatically input into the first table so that I can use it in a table of events that will link to the workshop page.
Is this too detailed for this forum? If so, I apologize! Hope it's not too confusing!
Thanks!
Kathy
