Ok im going to try to select my info in a backwards motion, meaning im going to select the products from the salesdetail table where the product_no = #pnumber# and see if I can get the referal from that direction...

I'll be back...