Have a report that references several tables from a database for a survey. The problem I'm running into is this:
The questions table is:
question_no
question
The questions options table is:
question_no
option_no
option_desc
The cust responses are:
question_no
option_chosen (related to the option_no)
response_text
The quesitons were set up like:
1. question
1.1 option
1.2 option etc...
or
2. question
response text
I'm trying to set this up with two subreports so that if I group I don't lose one set of data vs. the other. I've been back and forth here and am losing track of the big picture I think. Any help in direction would be appreciated.
Thanks.
The questions table is:
question_no
question
The questions options table is:
question_no
option_no
option_desc
The cust responses are:
question_no
option_chosen (related to the option_no)
response_text
The quesitons were set up like:
1. question
1.1 option
1.2 option etc...
or
2. question
response text
I'm trying to set this up with two subreports so that if I group I don't lose one set of data vs. the other. I've been back and forth here and am losing track of the big picture I think. Any help in direction would be appreciated.
Thanks.