I am developing an online application form, which can be of two categories, either domestic/international. Each different type has commong questions,
and also specific questions. They are approx 6 pages/steps of questions.
The application form can also be saved at the end of each step,
and can be completed at a later date. Some questions will vary depending on answers to previous questions, so there are some complex business rules.
In terms of storage of results, would it be best to store the answers in
and XML field in SQL? What would be the best way to reference a question to an answer. There is no need for the form to be dynamic in rendering questions etc.
e.g.
<Application id="123" type="Domestic">
<Answers>
<EmailAddress>
[email protected]</EmailAddress>
<HomePhone>555-5555</HomePhone>
<Suburb>MySuburb</Suburb>
<Guardians>
<Guardian type="Mother">
<FirstName>Mom</FirstName>
</Guardian>
</Guardians>
<Answers>
</Application>