>dear hilmar
>table 1 has field1,field2,fiedl3
>table 2 has field4,field5
>table 3 has field6,7,8,9,10
>table 4 has fiel11,12,13,14
>table 5 has field15,16
>thank you
Sure. I sent just an example.
In the example you give, you have to create field1..field16 for
each of the five tables, same structure for each, and combine the results with a UNION. Add an additional field, "table", that says from which of the 5 tables the data comes. This allows you to print conditionally - for instance, the first sub-report is only printed for the condition "table = 1".
HTH! Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)