Deleted a Record by moving to new fm

[Beylah]

I have created a sales database that I need to be able to delete records. But for privacy purposes the record cannot be deleted altogether, the auditor must see it at year end. So I was thinking to create a button that would actually just move the record out of the one db and into another for the auditor and call the new db Deleted Records. But I don't know how to do this.

Any help would be much appreciated. Thanks!

Edited January 31, 2007 by Guest

[Reed]

You could just have a script import the record into the other table prior to deleting it. You will have to create another table first.

You can easily create the duplicate table by using the import records command. In the dialog, set the target to "new table" which will create a new table with all the same fields as the imported table from the same file.

Once the table is created you can have your delete script isolate the records which are to be deleted, import those records into the other table, and then delete them from the original table.

Another thing you might want to look into is an audit tracking system.. One is from CNS, and the other is from nightwing. You should be able to find these by searching the forums. These systems will help you track any changes or deletions of records in an external audit table.

[Beylah]

Thank you for you reply it helped alot and I have it working as you said. There is still one probelm: I do a search and create a found set and then export them to the deleted file. But when I do another found set and try the same thing it writes over the existing data. what I would like it to do it to be additive. So I can keep building the deleted db as I buy new lists.

Beylah

[Reed]

you don't want to export to the deleted file, you want to call a script that imports into the file from the old file (with the add new records option)

That script will have to exist in the other file (if you want to use a separate file). You could also just create another table in the same file and do the same thing.

[Beylah]

thanks, i have done as you said and it is working great.