Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does VFP9 Reports support grandchild tables?
Message
From
20/12/2006 16:47:47
 
 
To
20/12/2006 15:41:51
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01179329
Message ID:
01179367
Views:
6
Thanks Dragan.

>>Hi Everyone,
>>
>>You can just respond to the question in the thread title. For a bit of an explanation (that might prompt a workaround), here is what the client wants.
>>
>>Law firm...wants to print detail of a single client file. Here are the tables and their relationships:
>>
>>MainTable: Plaintiff, heading detail (name, date of birth etc; used to print in header area)
>>
>>--> ChildTable1: contacts on this file (multiple, related to main by File_ID)
>>
>>--> ChildTable2: annuities purchased for plaintiff; multiple; related to MainTable by File_ID
>>
>>-----> GrandChildTable1: who purchased each annuity (multiple litigants may have contributed to purchasing the annuity); related to ChildTable2 by Annuity_ID
>
>You may try to set skip to grandchild table - that way the child2 would look as it has as many records as there are related records in the grandchild table. Sort of left outer join done by relation. Most of the time it's not really handy, but may just work in your case. Make sure you don't print repeated values from child2.
Previous
Reply
Map
View

Click here to load this message in the networking platform