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