Archiving and Restoring
I am running FM 12 2 Advanced on Mac and PC.
I have a membership application with a main table: Members and numerous related tables: committees, dues, awards etc...
The whole things works great. (Thanks FM and Thanks to this forum!)
In the vein of 'there is always something to do', I would like to provide an Archive feature whereby a specified member record AND their associated 'committee', dues, etc. table records would be (magically ) copied and pasted into an 'Archive'/duplicate database (called Members Archive) and then removed from Members.
I just can't get how to even get started implementing this. Anyone have any ideas? Thanks