Thread: Database Design

Alright...give this a shot:

Code:

SELECT Members.MemberID, ManagementLevels.Description, Forms.FormType
FROM ((((Members INNER JOIN ManagementLevels ON Members.LevelID=ManagementLevels.LevelID) INNER JOIN QuestionAnswers ON Members.MemberID=QuestionAnswers.MemberID) INNER JOIN FormQuestion ON QuestionAnswers.QuestionID=FormQuestion.QuestionID) INNER JOIN Forms ON FormQuestion.FormID=Forms.FormID) INNER JOIN FormType ON Forms.FormType=FormType.FormTypeID
WHERE Members.MemberID=4 And Forms.FormID=1;

Originally Posted by dtz

Hi jmurrayhead,
sorry to be a pain, iam still doing the database and trying to understand it, sorry i am new to it, thought if you could guide me please, the question for the form is pre determined and i was wondering in which table does the answer goes to once the user fill in the form please?does that mean each question have a specific field?Thankss a lot

The questions are stored in FormQuestions table. The response from the user is stored in the QuestionAnswers table, where the MemberID of the person submitting, the QuestionID of the question they are responding to, and the actual response are stored.

Each answer to each question is a separate record (as it should be). Does that make sense?

Hi,
thanks it makes sense now, so for the insert through a form, does that mean when the user fill in the form for each question i need to insert a member id as well?

Thanks in advance

That's correct. That's how you will be able to related that user's reponse (answer) to their member account