AnsweredAssumed Answered

Copy records from a table to another one

Question asked by paolosalvemini on May 14, 2015
Latest reply on May 15, 2015 by paolosalvemini

Title

Copy records from a table to another one

Post

Hello,

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?

Thanks

Outcomes