Editing and saving DB entry with new ID (index) number

[Dave Lagergren]

I need to edit an entry in an access database and then save it as a new
record. I have designed everything with DBW. The update.asp file gets the
edited info and writes it back in the same record. Submission_Form.asp
writes a new record. I can't figure out how to utilize the code in
Submission_Form.asp to save the output of update.asp. It is a huge hunk of
code but I can post it if needed. I created the website with FP 2003.

 

[Thomas A. Rowe]

Unless you are actually changing and saving an existing record back to the same table, you are not
editing the record.

In order to accomplish what you want, which is to load an existing record into Add Record Form,
which would then allow the current record to be modified and submitted to another table, may require
hand coding.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Thomas A. Rowe]

When you edit a record, you are writing the same record back under the same ID (key) with updated
info.

You have to load the record into an Add-Record form, which then inserts the updated record as a new
record in the same or another table in the same or different database within the site. This is
something that the FP database component is not designed to handle, so it must be a hand coded
solution.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================