PROBLEM:
I am producing a Survey Report for a class and cannot get the comments included with the correct questions.
I am guessing that the issue is my set design, since the browse I created based on the set cannot display the comments with the correct questions.
I am using a standalone desktop Alpha Five V10.
BACKGROUND:
The Survey uses questions that are grouped in categories. The user makes comments for each question.
The Survey Report needs to show tallied results and comments for all surveys submitted for that class.
Total number of tallied results by Category, then Question (number of Strongly Agree, Agree, Disagree, Strongly Disagree) and a calculation of the average for those Statistics.
Following the Stats, all comments from the users are posted.
? Class
o Category A
Question Statistics and comments
o Category B
Question Statistics and comments
o Category C
Question Statistics and comments
Tables provided are:
? Class Table containing the class info and stats and calculated averages.
? A Category table containing the category and which questions belong to that category
o Category A ? Questions 1-3
Q1
Q2
Q3
o Category B ? Questions 4-8
Q4 ?
Q8
o Category C ? Questions 9-10
Q9
Q10
? The Comment Table with Courseid, Question_No, Comment
My current set design shows the Class.dbf as the Parent , Category.dbf as Child and Comment.dbf as Grandchild tables.
Parent.Courseid
Child.Category
Grandchild.Comment
The Parent?s key field is the Parent.Class->Courseid as is the Comment?s key field (Grandchild.Comment->Courseid).
My issue is the Child.Category table. I can link the Child.Category->Question_no to the Grandchild.Comment->Question_No, but I have no real link of the Child.Category to the Parent.Courseid.
? Parent: Class->Courseid, Class->SurveyType
? Child: Category->Survey_Type, Category->Category, Category->Question_No
? Grandchild: Comment->Courseid, Comment->Question_No, Comment->Comment
The grandchild has the Courseid of the Parent and the Question_No of the Child
After 2 weeks of trials, I can display a report showing everything properly except the comments.
The comments are not displaying with the appropriate questions. They actually appear all together before the first category.
As I am the sole programmer on staff, I need a new set of eyes to provide a view I haven?t considered.
Any help is appreciated. Thanks!
I am producing a Survey Report for a class and cannot get the comments included with the correct questions.
I am guessing that the issue is my set design, since the browse I created based on the set cannot display the comments with the correct questions.
I am using a standalone desktop Alpha Five V10.
BACKGROUND:
The Survey uses questions that are grouped in categories. The user makes comments for each question.
The Survey Report needs to show tallied results and comments for all surveys submitted for that class.
Total number of tallied results by Category, then Question (number of Strongly Agree, Agree, Disagree, Strongly Disagree) and a calculation of the average for those Statistics.
Following the Stats, all comments from the users are posted.
? Class
o Category A
Question Statistics and comments
o Category B
Question Statistics and comments
o Category C
Question Statistics and comments
Tables provided are:
? Class Table containing the class info and stats and calculated averages.
? A Category table containing the category and which questions belong to that category
o Category A ? Questions 1-3
Q1
Q2
Q3
o Category B ? Questions 4-8
Q4 ?
Q8
o Category C ? Questions 9-10
Q9
Q10
? The Comment Table with Courseid, Question_No, Comment
My current set design shows the Class.dbf as the Parent , Category.dbf as Child and Comment.dbf as Grandchild tables.
Parent.Courseid
Child.Category
Grandchild.Comment
The Parent?s key field is the Parent.Class->Courseid as is the Comment?s key field (Grandchild.Comment->Courseid).
My issue is the Child.Category table. I can link the Child.Category->Question_no to the Grandchild.Comment->Question_No, but I have no real link of the Child.Category to the Parent.Courseid.
? Parent: Class->Courseid, Class->SurveyType
? Child: Category->Survey_Type, Category->Category, Category->Question_No
? Grandchild: Comment->Courseid, Comment->Question_No, Comment->Comment
The grandchild has the Courseid of the Parent and the Question_No of the Child
After 2 weeks of trials, I can display a report showing everything properly except the comments.
The comments are not displaying with the appropriate questions. They actually appear all together before the first category.
As I am the sole programmer on staff, I need a new set of eyes to provide a view I haven?t considered.
Any help is appreciated. Thanks!
Comment