Jim,

Nadya has already given you my standard advice. I've had so much grief from trying to run reports off related tables.

What you're missing is SET SKIP TO ChildTable.

But really, take Nadya's good advice. She didn't detail the fact that I never refer to data in the report as MyTable.MyField, but simply MyField. Then just make sure the report cursor is the currently select work area.


>How do you print data from two tables. The heading and footer parts are from one table and that is printing fine. The detail portion is from another table and I'm only getting one of the twenty records printing there?
>
>Any ideas?
>Colombo.