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,
Ronald Suen
Epic Information Solutions Inc.
Ph: (780) 488-4418
Fax: (780) 488-0402