So ...
1. Make a cursor with an Select - SQL command like the following:

Select TABLE_NAME.*, ;
TABLE_STATUS.STATUS, TABLE_ADDRESS.ADDRESS, TABLE_FAMILY.FAMILY ;
FROM TABLE_NAME ;
JOIN TABLE_STATUS ON TABLE_NAME.CODE = TABLE_STATUS.CODE ;
JOIN TABLE_ADDRESS ON TABLE_NAME.CODE = TABLE_ADDRESS.CODE ;
JOIN TABLE_FAMILY ON TABLE_NAME.CODE = TABLE_FAMILY.CODE

2. Use data grouping of the report (from the menu: Report-Data Grouping)

Note that I did NOT verified whether your relations are correct

HTH

< snip >
>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.
>
< snip >