Sweet. *sighs*

OK this wasn't so much of a doozie and I have to thank everyone for their assistance.

I got it to work and I did by going backwards instead of forwards, in other words,

instead of starting off by selecting the referer based on contact_id and sales_id stuff,

I first selected the product number from the salesdetail table,

then the sales_id from the same table,

then the contact_id from the sales table based on the contact_id in the salesdetail.sales_id

and then once I had that contact_id i fetched the referer from the users table...

the sql is all mixed in with coldfusion but if you need to see it just let me know and I will post it here...

Thanks everyone...