FM 14.04 adv backup and remove 'inactive' records.

Discussion created by synergy46 on Nov 16, 2015
Latest reply on Nov 19, 2015 by wimdecorte

What is the best 'method' to do this?  (via script)


I have a membership application.  It has 'active' or 'inactive' member status stored in the STATUS field.


I  want to write a script that will:

backup (save as...?) the MEMBER &  associated DUES, AWARDS etc.... tables to a user defined file and then delete the backed-up records in the main Membership app.    The expectation is that the user can 'import' these records back into the main app later.


From  what I see, using Save As copies everything.... (active and inactive).  Is there a way to use save as to copy just the 'found set' of 'inactive records'?