PRB: One-to-Many Report Prints First Child If Scope Is OneLast reviewed: December 14, 1995Article ID: Q140489 |
The information in this article applies to:
SYMPTOMSA one-to-many report with a scope of one record in the parent table does not display all the related records in the child table. Only the first related child record prints where the tables have a parent and child one-to-many relationship.
CAUSEIn one-to-many relationships, when you skip through the parent table, the record pointer remains on the same parent record until the record pointer moves through all related records in the child table.
RESOLUTIONTo have all the related records in the child table print for a specific parent record:
STATUSThis behavior is by design.
MORE INFORMATIONFor more information about how to specify a scope for a report in Visual FoxPro, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q135342 TITLE : BUG: Scope on Report Command Doesn't Work as It Did in 2.x Visual FoxPro Steps to Reproduce Behavior
Example ResolutionTo resolve this behavior, use the FOR clause of the REPORT FORM command, as in these examples:
REPORT FORM Test FOR Cust_Id = "ANTON" -or- REPORT FORM Test FOR RECNO() = 3 -or- REPORT FORM Test NEXT x where x is the number of child records related to the parent record. |
Additional reference words: 2.50 2.50a 2.50b 2.60 2.60a 3.00 3.00b FoxWin
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |