I have a form with basic info. such as name/date/printer and then about 8 different options each involving about 3 options for that section. The user can only select one of the 8 sections and then ofcourse the std. questions on the form. The table to store all this info. would be large to cater for all 8 options ... so I created 8 separate tables to store each option (this also alows to expand the details in each option if needed). Then I store a foriegn key in each table to match to the std (basic info.) table. Is this the best way to implement such a form. Should I store all info. in one table rather, or is spliting the info. over several tables better. Please let me know your thoughs. I will be using sql server + asp to store and retrive info. form the table/s.
Just to mention again that all these options are on one form all the options in ts_design need to be entered however the user chooses either a poster or a flyer or a advert etc... and this info is associated with the order table. I hope this is clear .. thanks again