Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
It's in the details...not : )
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement