m1kegbrown
Registered User.
- Local time
- Today, 04:01
- Joined
- May 2, 2003
- Messages
- 11
History:
We are using a form to associate a specific answer (given from an answer table) to a specific question (given from a question table) for a specific survey (given from a survey table) for a specific participant (given from a participant table). However each survey is not exclusive to each participant, each question is not exclusive, and each answer is not exclusive to each question.
Problem:
After the user has selected a participant, I want to display in a form each question (continous form) and next to it in a pull down (combo box) the associated asnwers. I then want the result to be stored to the participant.
Tables:
I have created 8 table:
participantTable: PID, firstName, lastName
surveyTable: SID, surveyTitle
questionTable: QID, questionWording
answerTable: AID, answerWording
questionAnswers: QAID, QID, AID
surveyQuestions: SQID, SID, QID
surveyParticipants: SPID, PID, SID
participantAnswers: PAID, PID, QAID
So far I am able to make the form post 8 correct question with the appropriate QID, but when I try to display the associated answers (which range from 4 - 7 answers per question) I get 48 results each with a unique question answer combination.
I need it to display the 8 questions each with there associated answers collaborated in a combo box
Any help would be greatly appreciated

We are using a form to associate a specific answer (given from an answer table) to a specific question (given from a question table) for a specific survey (given from a survey table) for a specific participant (given from a participant table). However each survey is not exclusive to each participant, each question is not exclusive, and each answer is not exclusive to each question.
Problem:
After the user has selected a participant, I want to display in a form each question (continous form) and next to it in a pull down (combo box) the associated asnwers. I then want the result to be stored to the participant.
Tables:
I have created 8 table:
participantTable: PID, firstName, lastName
surveyTable: SID, surveyTitle
questionTable: QID, questionWording
answerTable: AID, answerWording
questionAnswers: QAID, QID, AID
surveyQuestions: SQID, SID, QID
surveyParticipants: SPID, PID, SID
participantAnswers: PAID, PID, QAID
So far I am able to make the form post 8 correct question with the appropriate QID, but when I try to display the associated answers (which range from 4 - 7 answers per question) I get 48 results each with a unique question answer combination.
I need it to display the 8 questions each with there associated answers collaborated in a combo box
Any help would be greatly appreciated