m1kegbrown
Registered User.
- Local time
- Today, 12:56
- Joined
- May 2, 2003
- Messages
- 11
History:
I am converting testing data from a paper format into a DB ( using access). I need to have an easy to use UI. Most of the tables have been finished and the relation diagram is complete. However I am having problems getting the UI to populate and manipulate some of the data.
Problem:
There are multiple participant who took different surveys. each survey consists of a series of questions. Each question has a series of answers that are associated with it. A participant can only give one answer for each question. Questions are not exclusive to one survey, and answers are not exclusive to one question.
So far:
I have made a form where one can select the desired participant. Then by clicking a button a form to view the questions is loaded.
I have made a query that succesfully locates all the particular questions associated to a particular survey.
I have made a successful query that associates all specific question and answer combonations.
I have 8 tables:
participantTable: particpantID, firstName, lastName
surveyTable : surveyID, surveyWording, surveyDate
questionTable: questionID, questionWording
answerTable: answerID, answerWording
participantSurveys: PSID, participantID, surveyID
surveyQuestions: SQID, surveyID, questionID
questionAnswers: QAID, questionID, answerID
particpantAnswers: PAID, particpantID, QAID
when I run the query on producing the questions for each survey associated to a particular participant I get a single listing of each question which is correct. but when I run a query for the possible answers associated to these questions I get a seperate entry for each possible combination. What I need is listing of each question probably a continuous form) with a pull down (combo box) where I can select one (and only one) of the possible combonations. I then need this answer to be stored in the participantAnswer table.
I hope this is enough info. I have been stuck on this problem for 2 weeks now and can't seem to figure it out. Please help
I am converting testing data from a paper format into a DB ( using access). I need to have an easy to use UI. Most of the tables have been finished and the relation diagram is complete. However I am having problems getting the UI to populate and manipulate some of the data.
Problem:
There are multiple participant who took different surveys. each survey consists of a series of questions. Each question has a series of answers that are associated with it. A participant can only give one answer for each question. Questions are not exclusive to one survey, and answers are not exclusive to one question.
So far:
I have made a form where one can select the desired participant. Then by clicking a button a form to view the questions is loaded.
I have made a query that succesfully locates all the particular questions associated to a particular survey.
I have made a successful query that associates all specific question and answer combonations.
I have 8 tables:
participantTable: particpantID, firstName, lastName
surveyTable : surveyID, surveyWording, surveyDate
questionTable: questionID, questionWording
answerTable: answerID, answerWording
participantSurveys: PSID, participantID, surveyID
surveyQuestions: SQID, surveyID, questionID
questionAnswers: QAID, questionID, answerID
particpantAnswers: PAID, particpantID, QAID
when I run the query on producing the questions for each survey associated to a particular participant I get a single listing of each question which is correct. but when I run a query for the possible answers associated to these questions I get a seperate entry for each possible combination. What I need is listing of each question probably a continuous form) with a pull down (combo box) where I can select one (and only one) of the possible combonations. I then need this answer to be stored in the participantAnswer table.
I hope this is enough info. I have been stuck on this problem for 2 weeks now and can't seem to figure it out. Please help
