Backing up a deleted record? (FMP 10 Advanced)
I need to delete a customer. I just delete the customer record, but I'd like to keep a record of it. I could mark the customer as deleted, but that's a nuisance to remember when doing searches and exports.
What I'd like to do is add a new table of Deleted Customers and move that record from Customers into Deleted Customers.
Is there an easy way of duplicating the table schema and moving a record between tables like that?
Or any other good practice?