From the result page you can insert a hyperlink pointing to ex
changedb1.asp and add parameters for example
Frmfield1<%=FP_FieldURL(fp_rs,"field1")%> and so on for all fields you want
to pass over to the changedb1.asp page
In the changedb1.asp insert a form with the needed fields and insert in the
fields for example FrmField1 value <%=Request("field1")%>
From this new form with the dbfields click form properties | option | Action
wright (changedb2.asp) and then insert in formproperties | advanced a hidden
fields for example frmField3 value <%=Request("field3")%>
In the changedb2.asp insert dbresult chose your dbconnection and next click
custom query. Insert
for example
UPDATE yourdb
SET field1='::frmField1::', field2='::frmField2::', and so on for the fields
you want to change
WHERE field3=::frmfield3::
Maybe you can do this in an easier way. I use to do like this and it works
fine I do it all with FP functions.
The field3 should be an idfield.
From the changedb2.asp I use to do an autoredirect to the page I want to
return to.
Ted
Greg White said:
Hi: I have a database inteface and results page set-up. But I need to
create another form that modifies alows the user to modify one of the vaules
on the database after they have submited the orginal information. Its not
clear to me how to do this with when I have a form, database and results
page already set up. Thanks!
