In my ProBono application that uses SQLite to deal with persons, I suddenly have a question.
a. I set a New button to be able to add person(s). It clears the previous data and a click in the Add button add this new person. OK
b. It is so easy to Delete a card that I add a small window to avoid errors. OK.
c. I have a Modify Card button to be able to set a date for the person(s) that left the association (not for employees, for helped people). OK
d. An Add button add the current person. Usually to follow the New, then populated data. This adds a new persion in the data base.
I ask the association to make a backup at the end of december each year (export the data base to text and duplicate the .sqlite file). So, they have archival.
I also added a data base split (based on a set year), so they can remove too older years.
I am thinking that a History log can be useful. If I do that
a. how can I do it ?
b. what will I store there ?
Added persons (an added Record)
Modified data (a modified Record)
Deleted persons (a Record)
As usual, your input is welcome.