Jay;

Table A: Parent!
Table B: Child (A)
Table C: Child (A)

I created a table and save the records of B and C there! I do not create a cursor with SELECT - UNION because structures are different...

So:

Select TMP_Table
Report Form...

I enable the fields on report using "Print When"...

Sorry about my english... You have found mistakes here! I can speak Portuguese and just a little about English.

Thank you!

Rodolfo Duarte
Ribeirao Preto / Sao Paulo - BRAZIL!
rodolfo@computar.com.br

>>>I always have to print one table in title and three tables on detail...
>
>
>I wasn't able to determine from your table listings how the tables are related to one another.
>
>If the 3 tables are in a strict hierarchy -- parent, child, grandchild relationship -- you can create a single result set through SQL SELECT (in a query or view) with appropriate joins and use the group by bands of the report to sort things out.
>
>If you have a parent, child relationship and one additional table related to either one, the above approach will work.
>
>If you have a parent, sibling, sibling relationship (both siblings related to the parent but not to each other), you've got more work on your hands. Tamar did an article on this a couple years ago in Advisor. If I remember correctly, do 2 preliminary queries with each parent, sibling relationship. Then do a full join between the 2 preliminary queries.
>
>That is probably too much info. But, let us know where you're coming from and maybe we can home in on a solution.