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.