Report linking problem... can't find a solution

[MikeDNova]

Hey guys,

I have a few tables:

tblQuestion tlbCategory tblQuestionResponse
Focus CategoryID QuestionID
Question Page Text
QuestionID CategoryID
CategoryID

Now I'm trying to setup a report that prints out one question from tblQuestion at a time, along with the appropriate text from tblQuestionResponse. Each categoryID has a set of questions from tblQuestion. There are focus fields that are each related to a question that I am having a problem print. I want to print the focus fields at the bottom of the report after the questions and the text fields have already printed. I want it to look like
|Question| |Text |
this: |Question| |Focus |

This means that some of the questions need to be printed out twice. but i only want the second group printed after the first.

I've tried making a subreport for the question and focus but that hasn't worked. i thought that by using categoryID as the link child/master it would work.

any suggestions or questions???
i would appreciate all the help pretty stuck here.

Thanks,
Mike
mikednova@hotmail.com

 

[mkrausnick]

It looks from your field list like the focus field is in the question table? If so, you need only the question table to print the question/focus. Putting the single-table sub-report (using only the question table) following the multi-table question/answer sub-report should work.
Mike Krausnick