I am trying to create a solution that rather than deleting record completely from the database a log is kept in a .tab/csv file.

The problem is that I want it to be a file that is writen over but is added to and hence keeps a list of all the deleted names

Has any one got any ideas?

would it be best to add a new file and add the details to that?

Thanks

You'll need to use a file plugin, like Troi.