I sort of worked it out. There is a query in the
customeraction page that
looks a little like this(after modifying a tad):
<cfquery name="rsGetCustomer" datasource="#your.DSN#"
username="#your.username#" password="#your.password#">
SELECT cst_ID, cst_ShpCity
FROM tbl_customers
WHERE cst_Username = '#form.Username#' AND
cst_Password = '#form.Password#'
</cfquery>
I added it to the welcome page in my site that users are
directed to after
loggin in. I then submit their username and password to the
orderform.cfm
page as hidden fields in a form on the welcome page with a
submit button and
it successfully passed the information to CW.
Bob