PRB: Can't Print GrandChild Records in One-to-Many Relation
Article ID: 136674
Article Last Modified on 5/7/2003
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft Visual FoxPro 3.0b Standard Edition
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 5.0a
- Microsoft Visual FoxPro 6.0 Professional Edition
- Microsoft Visual FoxPro 3.0b for Macintosh
This article was previously published under Q136674
SYMPTOMS
A report for three tables, where the tables have a parent, child, and
grandchild one-to-many relation, does not display all the related records
in the grandchild table for each of the records in the child table. Only
the first related grandchild record prints.
RESOLUTION
To list all the related records in the grandchild table for each of the
records in the child table:
- Use the SET SKIP command. Place it in the Init event of the report's
data environment to set the one-to-many relation from child and
grandchild into the parent.
-or-
- Set the IntitialSelectedAlias property of the report's data environment
to the child table.
STATUS
This behavior is by design.
Keywords: kbprb KB136674