Yes I agree...

I've gotten a tad farther with my work and think I will be able to narrow down the referer by starting with the following queries;

<cfquery name="users" datasource="#request.dsn#">
select distinct sales_id from salesdetail where product_no = #pnumber#;
</cfquery>

<cfquery name="users2" datasource="#request.dsn#">
select contact_id from sales where sales.sales_id = #users.sales_id#;
</cfquery>

But for some reason when I try to output data from query users2 nothing is displaying but I'm SURE there's data there...

thanks again for your support CG, I'll get this surely in time...