PRB: Can't Print GrandChild Records in One-to-Many Relation (136674)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
- Microsoft Visual FoxPro for Windows 3.0b
- Microsoft Visual FoxPro for Windows 5.0
- Microsoft Visual FoxPro for Windows 5.0a
- Microsoft Visual FoxPro for Windows 6.0
- Microsoft Visual FoxPro for Macintosh 3.0b
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.
Modification Type: | Major | Last Reviewed: | 5/7/2003 |
---|
Keywords: | kbprb KB136674 |
---|
|