Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't Establish Relationship
Message
From
24/06/1999 21:01:47
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
To
24/06/1999 16:25:03
Ronald Suen
Epic Solutions Inc.
Edmonton, Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00233697
Message ID:
00233793
Views:
27
Ronald,

Try opening your two cursors in browse mode for the 5+22 CheqNo and step trhough as if you were the report.

>Hi all,
>
>I am trying to create a little cheque printing application but I am running into a weird problem. I have two cursor tables which are generated when the user clicks the Print Cheque button. One table is the Cheque Master which contains the information to be printed on the cheque. The other is the Cheque Detail which contains the information to be printed on the stub. The link between the two tables is the Cheque Number (integer). I establish the relationship prior to running the report.
>
>The report works when there are only a few records in the tables (2 in the master, 4 in the detail), but when I tried printing with more records (5 in the master, 22 in the detail), something went wrong. The report prints all the detail lines, but the cheque master fields are not displaying properly. The record pointer for the cheque master table is at EOF.
>
>What's going on and how can I fix it? I've pasted a copy of how I establish the relationship prior to running the report.
>
>SELECT csrChqDetl
>
>SET RELATION TO CheqNo INTO csrChqMast
>
>REPORT FORM (THISFORM.lcReportFile) PREVIEW
>
>Thanks in advance,
Previous
Reply
Map
View

Click here to load this message in the networking platform