I can't get customized pricing to work

[ddiabetes]

This is some sample data from the DT_customerPrices Table

SalesRep CustID ID custitemcode custPrice DateEntered Custnum
TE alldia 97 129G 10.00 4/18/2006 4497
LD ALLDIA 102 26B-6 50 11/13/2006 4455
DB ads 130 ACCO51 24.75 4428
DB ads 131 ACML 9.5 4428
DB ads 132 ACTMC50 24.95 4428
DB ads 133 AVMC50 25.43 4428
DB ads 134 AVMTR 27.5 4428
DB ads 135 CCHO50 24.25 4428
DB ads 136 COCS 4.58 4428
DB ads 137 FLASH 18.9 4428
DB ads 138 FSINMK 10.56 4428
DB ads 139 FTMO50 24 4428
DB ads 140 OTMC50 25.3 4428

Here is some sample data from the DT_Products table:

ID itemcode price description pic productsize taxfree brand searchcode title briefdesc
333 10100N $50.00 3" Walker Wheels images/products/10100N.jpg 1pr/bx dri hom 3" Walker Wheels with Rear Glide Caps, Grey 3" Walker Wheels with Rear Glide Caps, Grey
334 10100NBL 0 3" Walker Wheels images/products/10100N.jpg 1pr/bx dri hom 3" Walker Wheels with Rear Glide Caps, Blue 3" Walker Wheels with Rear Glide Caps, Blue
90 10100NG 0 3" Walker Wheels images/products/10100N.jpg 1pr/bx dri hom 3" Walker Wheels with Rear Glide Caps, Green 3" Walker Wheels with Rear Glide Caps, Green
335 10100NGL 0 3" Walker Wheels images/products/10100N.jpg 1pr/bx dri hom 3" Walker Wheels with Rear Glide Caps, Gold 3" Walker Wheels with Rear Glide Caps, Gold
336 10100NP 0 3" Walker Wheels images/products/10100N.jpg 1pr/bx dri hom 3" Walker Wheels with Rear Glide Caps, Pink 3" Walker Wheels with Rear Glide Caps, Pink
337 10101N 0 3" Walker Wheels images/products/10101N.jpg 1pr/bx dri hom 5" Walker Wheels with Rear Glide Caps 5" Walker Wheels with Rear Glide Caps