Cathy,

Thanks for your reply, but I probably need more information to nail down this report solution.

I have Parent table DD_Lar (the one side of the one-too-many relationship).
I have two Child tables DD_LarAppDwg, and DD_LarAppTsk. Both are many side of one-too-many relationship with Parent table.

One Many
------------- -------------------
DD_LAR.lr_rcn ---------> DD_LARAppDwg.rd_rcn
---------> DD_LARAppTsk.rt_rcn

In Report there is tabular (row/col) format with the DD_Lar data on top, and nested beneath this none, one, or both DD_LARAppDwg, and DD_LARAppTsk records in that order.

LR_Number LR_Projid LR_Desc ........
--------- --------- -------


Drawings: RD_DwgNum RD_Desc .......


... ...

Tasks: RT_TaskNum RT_Desc ........


... ...

I tried several grouping schemes with the proper SET RELATION on _Rcn field between parent-->child tables, and couldn't get report to work right.


Thanks,

Fred Z

Don