I'm trying to now design the back end for a gigantic web form. The web form consists of a number of seperate pages...
There are two pages that every form will include... (Information and General page) and then there are 13 other pages that may or may not be included based on user's input. I'm trying to decide how to create the database.
I'm thinking of having the information form as the core form with an id and timestamp for the entire form being done. Then a second form that contains the user id and form IDs for the subsequent forms so that I can pull which forms are actually associated with the form entry.
finally have each form as its own table..
Does that make sense? Any suggestions?