Dan,

The easiest way I've found is to put ALL the data into a single cursor. In the past I've done it with UNION, although you can also do it with APPEND if you have a read/write cursor. Add a field which is coded for each of your child tables: 1 for the first to print, 2 for the second, etc. Then each child will print in turn on the report.

If the field names are different, you can overlap the records for the different child tables, using Print When to make them visible/invisible as required. I find it easier to design the cursor so the fields are named (in the cursor) the same for each child.

HTH
Barbara

>Is there a way to generate multiple child detail bands in the report writer. I have three tables, parent.dbf, child1.dbf, child2.dbf. I would like to relate the parent to both children and generate detail for child1, and then detail for child2 on the same report. Can this be done with the VFP report writer?
>
>So for I have come up with populating a memo field with data for one of the detail bands, and reporting on the memo field before or after the detail of the other child. However, I don't really care for this approach if I don't have to use it.
>
>Thanks for any help in advance.