Copy records from a table to another one
I'd like to copy records from a table to another one when a condition is met.
I need to move a record from table "possible clients" to the table "Clients" if the field "became_client" is flagged.
All the other fields are the same. The script should copy the entire record to the other table and remove it from "Possible clients".
I know that maybe the best thing would be use only the table "Clients" but i do need also the other table (It's more confortable for me)
Can you help me?