AnsweredAssumed Answered

Moving records between tables

Question asked by sharontricorp on Feb 16, 2011
Latest reply on Feb 16, 2011 by sharontricorp


Moving records between tables


Hi all. I was wondering if it is possible to automatically move a record from one table to another using a script. We are trying to simplify our inventory so we have split off our inventory into 2 tables, one for active equipment and one for disposed equipment. We are trying to make it so that based on a specific change of a numeric value in our active table the record transfers over to the disposal table. Is this possible? Thanks in advance.