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'?