John,
The simplest way I've found is to get a report cursor with a row for each entry. You can try to set up a single gigantic SELECT statement, or simply add to the cursor. Basically you have a field (or fields as required) for each child table PLUS a field that stores a code for each ("A"rchive, "T"racking, etc.).

Parent ID  ChildCode   Child1       Child2     Child3
1          A           Yes
1          A           Probably
1          T                        08/8/00  
2          I                                    $27.00
2          A           Yes
2          T                        07/31/00

Then in your report you order the cursor by ChildCode within each Parent grouping, and print the data using the Print When field to blank out fields not used for a specific ChildCode.

Hope this is clear. If not, let me know.

Barbara

>Hi all,
>
>Unfortunately I don't get to work with VFP as much as I used to and
>I've been busting my brain for a couple of hours now trying to figure out how in the world to get this one-to-many report to work.
>
>I have a parent table with three (many) children tables(tracking,archive,inspectorlead). These child tables are holding tracking and archived information and are related to the parent by a parcel code field. What I need is a report that shows the parent information and all of the entries from each of these tables. There could be from 0 to possibly 10 detailed records in anyone of these three children tables. I can get this to work with only one of the three tables (querying into one cursor), but add the other two and things go horribly wrong. I would like to use a cursor or a view as my data source so that relations are not needed other than to query the data.
>
>I would appreciate any ideas from the experts!
>
>Thanks.
>
>john.