Question about passing data from cursor to data environment

I use the following code below to try and pass data from a cursor in the VFP Data Environment to be used in a report. When I do this, no data shows in the cursor named item_desc. item_desc1 is the cursor in the .prg file that I use to hold the data for the report. I have done a BROWSE on this cursor before trying to pass data to item_desc, and the data that I need sits in there. Also, I am trying to do this in the Made2Manage ERP system. The M2MSelect statement is used to query data from the SQL server and Foxpro tables contained in the report. Any help would be great!

Thanks,

BradStart Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:

*** USED TO FILL CURSOR item_desc WITH PART DESCRIPTIONS ***
M2MSelect('SELECT RPJOTS.fpartno, inmast.fdescript ' + ;
	'FROM RPJOTS, M2MDATA!INMAST ' + ;
	'WHERE rpjots.fpartno = inmast.fpartno ' + ;
	'INTO CURSOR item_desc1',SET('DATASESSION'),,'')
	
	SELECT item_desc1
 
INDEX ON (fpartno) TAG ALL
Browse
 
INSERT INTO ITEM_DESC VALUES ;
SELCT * FROM ITEM_DESC1