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