Sure!

SELECT parent.id,child.* FROM parent,child WHERE child.parentkey = parent.primarykey INTO CURSOR ORDER BY parent.id,child.id xxx

Then use xxx for reporting and print the Parent ID in a Summary band.


>I have a PARENT table and four CHILD tables:
>PARENT, CHILD1, CHILD2, CHILD3 & CHILD4
>
>I want to print ONE record from the PARENT table and then all the records that match in the CHILD1 table, then CHILD2, then CHILD3 and CHILD4.
>
>PARENT (ONE RECORD)
>CHILD1 (ALL RECORDS THAT MATCH)
>CHILD2 (ALL RECORDS THAT MATCH)
>CHILD3 (ALL RECORDS THAT MATCH)
>CHILD4 (ALL RECORDS THAT MATCH)
>
>Is there any way to do this in VFP?
>Thank you in advance.