If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
At-your-survey db. Using a temp table for customised forms.
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. |
Thread Tools | |
Display Modes | |
|
|