Sherry,

I second Ken's advice. To go a little further, you'll have the best luck if you refer to your fields as MyField only and not MyTable.MyField or MyCursor.MyField.

When the SQL code to create the report cursor is run immediately before the REPORT FORM command the cursor will be the current work area.


>Hello All:
> Could someone tell me what am I doing wrong: I am trying to produce a report with two tables -- clients and transactions. The relation is right I browse it but the report is not right. The report prints out each transation on each seperated page. I put all the client info. on the page header area and all the transactions on the detail area. I also created a data grouping on client_id. These are my codes:
> select transactions
> set order to client_id
> select clients
> set relation to client_id into transactions
> SET SKIP TO transactions