Questionnaire using DataAssist

Hi

Anything to consider when building a questionnaire to record people's views/opinion using DataAssist?

I'll need the visitor to register (Security Assist) then I show them a series of questions that have multiple answers. Record their answers in a database and show the results on the website.

The questions would be beside radio buttons recorded in the database 1, 2, 3 etc. Anywhere I could see the sql, how many tables etc. Plus, once the sql was written would DA build the questionnaire?

Any tutorials, threads or methodology?

Thanks

Regarding the tables, you would define how you would want the survey to work in terms of the data your were collecting. It's your app, so design it as you see fit.

Something along the lines of:

Questions
Options
Responses

Or maybe you just need Questions and Responses if your answers aren't dynamic.

It all depends on how you want to model your app.

Your results would be done by queries with joins so that the answers relate to the questions. You might also want to consider things like:

- Do you want to be able to report on the dates that the questions were answered
- etc etc etc

My advice when designing any development project is sit down and plan it on paper, and then build around your plan. Don't dive into the application straight away and build it as you go along. You can run into no end of issues.

Good advice. WA temps you to dive in when paper planning is the place to start. Thanks Ian

Ian, your advice is solid. Paper planning is essential when creating any web application.