2 or more detail bands, right? I did this more than once.
Select your data (perhaps with a UNION), to have the detail records in different records. Have a field "origin" to indicate where the data came from.
Put fields for the different details in the detail band, and use conditional printing.
HTH, Hilmar.
>My Friends Problem..............
>
>Loook Like These...
>
>suppose i have 3 table like this:
>
>TABLE_NAME
>CODE NAME
>0001 HENRY
>0002 TANNY
>0003 PETER
>
>TABLE_ADDRESS
>CODE ADDRESS
>0001 JAKARTA
>0001 JOGJA
>0002 SEMARANG
>0002 SALATIGA
>0003 JAKARTA
>0003 SEMARANG
>
>TABLE_STATUS
>CODE STATUS
>0001 FATHER
>0001 HUSBAND
>0002 MOTHER
>0002 WIFE
>0003 SON
>
>TABLE_FAMILY
>CODE FAMILY
>0001 00002
>0001 00003
>
>
>RELATIONSHIP BETWEEN EACH TABLE IS:
>-----------------------------------
>
>TABLE_STATUS <<---> TABLE_NAME <--->> TABLE_ADDRESS
>
>TABLE_FAMILY <<---> TABLE_NAME
>
>
>HOW CAN I DISPLAY THE INFORMATION ABOVE INTO VFP REPORT LIKE THIS:
>
>CODE NAME
>000001 HENRY
>
>NUMBER ADDRESS
> 1 SON
> 2 HUSBAND
>
>NUMBER STATUS
> 1 SON
> 2 HUSBAND
>
>NUMBER FAMILY
> 1 TANNY
> 2 PETER
>
>in MS.ACCESS this situation can be handled by report and sub-report that available in report designer, but we all know that VFP does not have sub-report condition in report designer and ONLY CAN DISPLAY 1 DETAIL ROW. how must i do to display report that i need from table that i have.
>
>thanks a lot for yours attention to my problem, i need this to finish my job
>
>henry....
>
>
>tut_arie
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)