[RESOLVED] Sub Report Question CR

Hey,
I have a report that lists the detail of a table. In each detail line I need to display data from another table that will display the records matching an ID number from the main reports detail line....

Do I need a subreport to do this? If so how would I pass the criteria to the subreport from the main report?

Any ways to do it without a sub report?

Here's a psuedo example of what I am trying to accomplish:

VB Code:

IDNumber IDDetail MoreIDDetail
       IDNumber IDDetailFromOtherTable
                     IDDetailFromOtherTable
                     IDDetailFromOtherTable

One way to do it would be to insert a Group section based on IDNumber from your main table, the group header would contain "IDNumber IDDetail MoreIDDetail", then the details section would contain the related data from the other table. Does that make sense?

Thanks, that probably the best way to go.