You need a database application for this.... I'm not aware of any free ones, but it should be relatively simple... Here's a little SQL Server Schema that I put together to show you an example of how you might structure a survey database:
Code:
CREATE DATABASE survey
GO
USE survey
GO
CREATE TABLE person (
id int IDENTITY (1, 1) NOT NULL,
username varchar (255) NOT NULL,
password varchar (255) NOT NULL,
full_name varchar(255) NOT NULL,
ip_address varchar(255) NOT NULL
)
GO
ALTER TABLE person ADD
CONSTRAINT PK_person PRIMARY KEY CLUSTERED (id)
GO
CREATE TABLE survey (
id int IDENTITY (1, 1) NOT NULL,
name varchar (255) NOT NULL,
title varchar (255) NOT NULL,
description varchar(255) NULL
)
GO
ALTER TABLE survey ADD
CONSTRAINT PK_survey PRIMARY KEY CLUSTERED (id)
GO
CREATE TABLE question (
id int IDENTITY (1, 1) NOT NULL,
survey_id int NOT NULL,
number int NOT NULL,
name varchar (255) NOT NULL,
value text NOT NULL
)
GO
ALTER TABLE question ADD
CONSTRAINT PK_question PRIMARY KEY CLUSTERED (id),
CONSTRAINT FK_question_survey FOREIGN KEY (survey_id) REFERENCES survey (id)
GO
CREATE TABLE answer (
id int IDENTITY (1, 1) NOT NULL,
question_id int NOT NULL,
number int NOT NULL,
name varchar (255) NOT NULL,
value text NOT NULL
)
GO
ALTER TABLE answer ADD
CONSTRAINT PK_answer PRIMARY KEY CLUSTERED (id),
CONSTRAINT FK_answer_question FOREIGN KEY (question_id) REFERENCES question (id)
GO
CREATE TABLE response (
person_id int NOT NULL,
question_id int NOT NULL,
answer_id int NOT NULL
)
GO
ALTER TABLE response ADD
CONSTRAINT FK_response_person FOREIGN KEY (person_id) REFERENCES person (id),
CONSTRAINT FK_response_question FOREIGN KEY (question_id) REFERENCES question (id),
CONSTRAINT FK_response_answer FOREIGN KEY (answer_id) REFERENCES answer (id)
GO