At-your-survey db. Using a temp table for customised forms.

Dear everyone and Mr. Hookom,

I have a questionaire db much like the "At Your Survey" db.
I'd like to have customised input forms for each
questionaire as they differ a lot.
For each answer session I'll create a temp table with one
field per question which'll be the record source for an
unbound form. This setup will be used both when editing
old responses and entering new ones.
This temp table will off course have a variable number of
fields/types since the questionaires have different
numbers of questions.

Now - some questions in many of the questionaires might
not be answered which leaves empty fields in the answer
table.
So I was thinking that perhaps I don't have to store
blanks at all in the answer table?
From the Questions-table I'll know the number of questions
and datatype so, when editing/entering a questionaire it
should be possible to fill the right fields ind the temp
table and leave out the blanks when saving the to the
answer table.

Do any of you who know this db setup see any problems with
this or have run into problems with this?

I can see that "At Your Survey" stores the blanks but I
thought that it may not be necessary.

Sorry for this long explanation and thanks for you time.

You should study the "at your survey" database in more detail. It doesnt
store blank records, and it doesnt put questions in variable numbers of
fields. When you understand how it works, and how it solves all those
problems, you should be well on the way to a good database design.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
"Jesper F" wrote in message
...
Dear everyone and Mr. Hookom,

I have a questionaire db much like the "At Your Survey" db.
I'd like to have customised input forms for each
questionaire as they differ a lot.
For each answer session I'll create a temp table with one
field per question which'll be the record source for an
unbound form. This setup will be used both when editing
old responses and entering new ones.
This temp table will off course have a variable number of
fields/types since the questionaires have different
numbers of questions.

Now - some questions in many of the questionaires might
not be answered which leaves empty fields in the answer
table.
So I was thinking that perhaps I don't have to store
blanks at all in the answer table?
From the Questions-table I'll know the number of questions
and datatype so, when editing/entering a questionaire it
should be possible to fill the right fields ind the temp
table and leave out the blanks when saving the to the
answer table.

Do any of you who know this db setup see any problems with
this or have run into problems with this?

I can see that "At Your Survey" stores the blanks but I
thought that it may not be necessary.

Sorry for this long explanation and thanks for you time.