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.