Post reply

how to save "application form" in the database

  • January 18, 2010 at 7:48 am

    #229168

    I'm building an application that processes application forms. I'm hoping I can get an advice on how to approach it properly. There are 4 forms right now but it will have a possibility of having more. Most of them have the same fields but each have 4 or 5 items not existing within other forms.

    What is the best way for me to store this data (and what sql data type) for me to easily retrieve and update it. I am using SQL Server 2005.

    Thanks.

  • January 18, 2010 at 8:01 am

    #1104949

    I'm going to give unpopular advice.

    Store the data in a properly normalised table design, with each piece of data in a column with an appropriate data type, tables fully normalised and related correctly to each other.

    That is the best way to store data. It's going to take the most up-front work, but will work the best in the long-run.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 18, 2010 at 9:15 am

    #1104994

    I've thought about it until management put up a rule that the admin should be able to edit the application form itself (e.g. add/remove fields).

    Sorry if I didn't mention it during the post.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply