I have 2 tables in my database. One contains records of jobs I have requested. The other contains jobs I have completed. I want the view the requested jobs database and select one for completion and have that automatically populate a few fields in the completed table. I don't quite know where to start with this. Could anyone please help me? thanks!
what's DB sys ?
IF oracle,you can use trigger
If mysql,you should write some script by PHP
just like
insert into ....select field_name from table_name where ...
It would be simpler to have a "completed" or "status" field, and just change the value to determine whether it is completed or current.
