>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
Access can do it ? Good. VFP could do it too :) in at least 3 ways.
1) With relations try : set skip to child1, child2
2) First select all the data into cursor then use that cursor for report data source
3) Way 2 with views
Yet there are other ways :) But I think 1 and 2 are easy ones for you to implement.
Cetin