>Hello Naomi,
>
>I split up the SQL statement so I could try and pinpoint the problem (see SQL below).
>
>After executing the first 2 SQL statement everything is OK.
>
>The records multiply after the 3rd SQL statement is run, so the problem is within the 3rd stament.
>Can you help me figure out why?
>
>Thanks again,
>
>John

>		SELECT Rv_uxdetail.custcode, Rv_uxdetail.itemnumber ;
>		FROM rv_UXDETAIL ;
>		WHERE ALLTRIM(rv_UXDETAIL.CUSTCODE)=="R02415" ;
>		GROUP BY Rv_uxdetail.custcode, Rv_uxdetail.itemnumber ;
>		INTO CURSOR cr_Items
>
>		SELECT Cr_items.custcode, Cr_items.itemnumber, Rv_arcus.priclist ;
>		FROM cr_Items Cr_items ;
>	    INNER JOIN rv_ARCUS ;
>	   	ON Rv_arcus.idcust = Cr_items.custcode ;
>		INTO CURSOR crs_PriceList ;
>		ORDER BY Cr_items.custcode, Cr_items.itemnumber 
>
>		SELECT Crs_pricelist.custcode, Crs_pricelist.itemnumber,;
>		Rv_icpric.desc, Crs_pricelist.priclist, Rv_icpric.baseprice,Rv_icpric.baseunit ;
>		FROM crs_PriceList Crs_pricelist ;
>	    INNER JOIN rv_ICPRIC ;
>		ON Rv_icpric.itemno = Crs_pricelist.itemnumber ;
>		INTO CURSOR crs_CurrentPrice

Do you have multiple records in RV corresponding to crs_PriceList?