This was what i meant to put in instead of qgetcustomer query So am I still missing a join somewhere
<cfif isdefined("url.invoice")> <cfquery name="qgetcompanyno" datasource="#request.dsn#"> select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum from INVOICE where INVOICE_Key = #url.invoice# </cfquery> <cfset form.INVOICE_Number = qgetcompanyno.INVOICE_Number> <cfset form.COMPANY_Number = qgetcompanyno.COMPANY_Number> </cfif> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4