Moving data from one table to another?

Originally posted by : BeginnerI am developing a small web application. I need to Update one field in a table while moving 4 fields from that table to another.What would be the best approach? Include file, stored procedure or multiple sql statements?Example of what I am trying to do:First I use a form on page 1 that queries table1 and return Data on page 2. Second they click a submit within a form on page 2 which UPDATEs a Field in Table1As that happens I would like to Move about 4 Fields from the record set that was update into Table2Examples would be helpful,Thank you,

Is this a maintenance action or should that run on a regular basis?