With regular single band report, i use to do a SELECT SQL....INTO CURSOR myreport AND then do my report based on the fields from the cursor myreport.

I am trying to do the same with multi-band vfp9 reports without success:

example:
SELECT idclient, name FROM arclient INTO CURSOR myreport
SELECT invoiceno, amount, idclient FROM arinvoice INTO CURSOR mysubreport1
SELECT myreport
SET RELATION TO idclient INTO mysubreport1

In the property of the report detail band, I put 'myreport' and 'mysubreport1' in each of them.
When I run, it says 'mysubreport1 does not relate to the current work area'.

I think there is something I don't understand.
Any idea

Many thanks