>I think I may see the light in using subreports. For the 'parent' report, I
>could simply group by eqgroupname and for the 'child' report I could group by
>partname. Is that what you had in mind?
Sort of, yes. For the primary report, you would do the 1:M on equipment, and in the subreport, 1:M on partname, and link them together on workorder.
It's a bit easier to do than describe... :-)