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.