Galia,
Use a cursor instead of the parent/child tables, so that all the data is in the same cursor. You can add a field and fill it with '1' for the first child, '2' for the second, etc. Then use ORDER BY with this field to order the results.
HTH
Barbara
>Is there any way the data from several child tables to show in the band "Detail" in the Report Designer ?
>
>I have one parent table which is related to four other child tables. I want to show all matching records from first child table in the band "Detail", under those records I want two place all all matching records from second child table in the band "Detail" etc.
>
>
>
>Sincerely,
>
>Galia Cvetkova