Report with Two Detail Sections?

[beribimba]

Hello,

I think this should be easy, but I'm not seeing how to do it.

Here's the setup (with fake variables): I have a table with three fields: person, foods, and colors. Foods and colors are both lookup fields with multiple selections allowed.

I have a report that is grouped by person and the detail section is each food associated with that person.



Now I want to add a separate section underneath the food detail section that lists the colors associated with the person. Can I add a new detail section? I want to use a nice table format that I've created with a detail header and footer, so I don't want to just stick it in the person detail footer or anything.

Thanks! I hope this makes sense.
Nick

[tcheck]

I would create a sub report with the primary link to the person and the colors listed in the report.

[beribimba]

Thanks! Worked like a charm. I didn't know there was such a thing as a subreport. Noob .