Hi. All
I don't know..Have sub-report in VFP? I want report one-to-many.
But more than 2 table in my report..I have one main table and 2 child tables relation one-to-many..How I can solve?
This is example Talble

Main Table
--------------------------------------------------
ID NAME AGE
--------------------------------------------------
01 NARONG 32
02 JOHN 35
03 JIM 25
--------------------------------------------------

OR Table (Child table1)
-----------------------------------------------
ID DIAG OPERATE
-----------------------------------------------
01 A001 0010
01 B002 0100
02 B002 0100
03 A001 0010
03 C001 1000
-----------------------------------------------------

Nurse Table (Child Table2)
-----------------------------------------------------
ID Nurse
-------------------------------------------------
01 Nancy
01 Mam
01 Janny
02 Mam
02 Nancy
03 Nancy
03 Mam
03 Janny
03 Anna
-----------------------------------------

I want report for these table I can do it..I know in ACCES have sub-report can solve my problem ..but in VFP ..How I can do?

Narong