Ronald,
If these are cursors (not tables) then why not combine the data into a single cursor. Yes, you'd be duplicating information for the cheque master, but it's a temporary table. With a single table there would be no relation problems.

If these are tables, then consider a single cursor combining data. I've found this is MUCH easier for almost all reports.

HTH
Barbara

>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,