Matt,

Your approach is fine as long as you get the SELECT to be union compatible. This usually involves adding some dummy fields to one child or the other.

You are trying to accomplish something that FPW report writer doesn't support--a "multi-scan" of child records. Concentric's R&R Report Writer has done this for years, and it's a great feature.

The only alternative to your approach within VFP that I have successfully implemented is to insert report objects whose expressions are UDF's in a wrapper program. The UDF's create the formatted child text (complete with CR-LF's) and you set the report objects to stretch.

Randy

>I need to run a report based on a parent account table and two children: submissions and results. I would like the output to look like this:
>
>Parent Rec1
> Child1 Rec 1
> Child2 Rec 2
> ...
> ____________________
> Child2 Rec 1
> Child2 Rec 2
> ...
>Parent Rec2
> (etc.)
>
>My solution is to do a union select:
...
>Then report on the cursor and show the appropriate fields according to groupid.
>
>Is there a better way?