Hi!

Just prepare cursor for your report properly:

SELECT PARENT.*, CHILD.* from PARENT LEFT JOIN CHILD ON PARENT.ID=CHILD>Parent_ID WHERE ... ORDER BY PARENT.NAME INTO CURSOR ...

Note that ordering is important here because the order field will be used for grouping in report.

Than select that cursor as a current and run report. Report takes it values from the current alis if nothing opened in the report data environment.

To display parent/child info in the rpeort, use grouping. For above SELECT statement grouping expression will be by NAME field used for sorting (It might be more complex in your case). Than in details display information from child fields. Information from parent fields could be displayed in the group title and/or footer. If child records do ne exist for some parent record, you will get all .NULL. values in the child fields. In the report there is the "Print When..." option for controls, where you can put a logical expression to do not print control in some cases - like .NULL. values for example. Check also checkbox to do not print details line of information is empty. This way you will get only parent record without children.

HTH.

>Hi all,
>
>I'm sure this topic has been discussed before, so forgive me. But is there a simple way to get VFP 6.0 to print
>detail lines from multiple child tables? I want to print detail lines from two different tables in two different areas on
>my report, but I do not know how to do this.
>
>Microsoft Knowledge base has a solution published (Q119354), but it seems that there ought to be a simpler
>solution for what must be a common need. Someone please tell me that I'm overlooking something.
>
>Thanks in advance.
>
>Fred E. Beaulieu