Is it possible to move a record from one table to another without physically copying, pasting and cutting.
I.e. we have two membership lists. One for current members one for past members. (It's a history thing)
If I set a current member's status to lapsed, is there a way that the record can...