You are right Naomi,

That was it.

These are how my 3 SQL statements should be (please take a look at the 3rd one). I had not included the PRICLIST comparison.

Now I will combine them all into one SQL statement.

Thank you!

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 AND RV_icpric.pricelist = Crs_pricelist.priclist ;
INTO CURSOR crs_CurrentPrice