What I've don is created a group with using the field called seq_nb and then I have added to the report in that group the field called "question".  This works fine and sorts the questions in order but I would like to have the "answer" next to the question.  The answer field is in a different table that uses a field called CS_Result_Detail_RecID to that appears to auto increase for each entry made into the table.  There is another field that ties from that table into the table with the question of course. But how can I tell crystal to grab all the answers, sort them and then display them next to the question?

 

I'm assuming there is going to have to be some sort of count of the seq_nb to know how many answers there are and then a for/next to grab the answer in relation to the number of the question. 

 

Any suggestions?