Script to move records to another table?
Hi. I have been using FileMaker for a banking database. I want to be able to archive old accounts by moving them to another table, or maybe even another FIleMaker file all together. I was wondering if there was a way to script this. I could create a radial button or something to state an account is closed, but I am not sure how to script or if it is even possible to script moving these accounts. Also, I have a table of deposit history for all accounts. I would need to move all records of each deposit from each closed account. These are all related by a Bank ID each account has. Any help is greatly appreciated. Thanks!