Our site has a series of eForms that a user fills out. Some of the forms are very long. They want to be able to have tabs at the top of the page where they can go from one form to the next and back again for more system flexiblity. Currently, each for the forms has it's own file and it's own corresponding table in the database.
The site is programmed in asp (not .net). I have an idea that to create the tab format and to be able to retain all the fields as they move from one tab to the next I'll need to combine some of the files into one file and then display or hide depending on which tab they've clicked. But when they save the form as a whole - I'm unsure if it's more efficient to save all the fields to one table or to break up the form into several smaller logical tables.
Currently, each of the tables has about 100 fields. If I start combining them I feel like the table structure is getting out of control.
Does anyone have any advice on how I'm going to set this up?