Show other data in group footer

[RBSTR]

Hi

I am writing a new Crystal Report in a VB6 application. This application currently uses Crystal 8.5

The report shows 2 levels of data - customer information and then all orders for that customer. The design I'm thinking of would have a group header for each order. In the group footer of the order I also want to show data from another table relating to that order. My report layout may be:

REPORTHEADER: Customer BOB001

GROUPHEADER:
DETAILS: Order lines for ORDER101
GROUPFOOTER: Select Messages From tblOrderMessages Where OrderNo = ORDER101

GROUPHEADER:
DETAILS: Order lines for ORDER105
GROUPFOOTER: Select Messages From tblOrderMessages Where OrderNo = ORDER105

GROUPHEADER ... etc

REPORTFOOTER

I'm not sure how to code into VB/format my Crystal Report to report this other data ('Messages') in the GROUPFOOTER for each order. I thought about a subreport but am unsure how to programatically get the subreport to only output the 'Messages' relating to the order currently being reported in the group.

Hope you can help.

 

[RBSTR]

Looks I can achieve what I want through creating subreport links.