Re: FW: thanks

I agree that the new field in the REQUEST table is the best way to go. I
am having a problem getting the variable to update that new field, I called
ASSIGN.

My form for making the assignments, inserts a new record, made up of data
queried from the REQUEST table and INPUT from a form. I pass those
parameters off to a new cfm to INSERT into a table called STATUS, where
or how do I get a variable to pass to the REQUEST table to UPDATE the field
ASSIGN with the value YES. My question is how can I INSERT into one table
and UPDATE another from the same form or can I? I have tried just passing
the variable to the cfm with:

<FORM ACTION="addnew.cfm?Assign=YES" METHOD="POST">

That doesn't seem to work. I even tried:

<FORM ACTION="addnew.cfm" METHOD="POST"><INPUT type="hidden" name="ASSIGN" 
value="YES">

That didn't seem to work either.

This is the statement I used in addnew.cfm for insert and update:

<CFINSERT
DATASOURCE="Survey Status"
TABLENAME="status"
FORMFIELDS="Receiver, Received, Requestor, CostCode, ProjectNo, GrpNo, T, N, R, 
E, ProjectName, Specials, Assignments, SupAssignments, Surveyor">

<CFIF IsDefined("assign")>
<CFUPDATE DATASOURCE="Survey Status"
TABLENAME="request" FORMFIELDS="Assign">
</CFIF>