From: Tamar Granor
Pennsylvania - United States
To: Barak Ros
Visual FoxPro 6
Databases, Tables and SQL Server
Monday, June 27, 2011 10:51:16 PM
This message was rated by:
# Ratings: 2
> I need to set relation between a father table and 2 sons tables, so I can print a report that shows for each father row , the rows related to it in the 2 sons tables.
Barak - this is much easier in VFP 9, but if you have to do it in VFP 6, check out the section title "Reporting on one parent table and all its child tables" in this article (
) on my website.
I saw farther down the thread that your child table structures are different from each other. To handle that, you can set up fields in the combined cursor that come from only one table or the other and then use Print When conditions in the report. The report itself will be ugly, but it'll work.
Posted by Barak Ros @ 6/26/2011 3:24:06 PM
Posted by Samir H. @ 6/26/2011 4:14:09 PM
Posted by Barak Ros @ 6/26/2011 4:26:38 PM
Posted by Samir H. @ 6/26/2011 4:32:56 PM
Posted by Barak Ros @ 6/26/2011 4:38:23 PM
Posted by Samir H. @ 6/26/2011 5:05:51 PM
Posted by Tamar Granor @ 6/27/2011 10:51:16 PM