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