Glad you solved it.

>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