I have a database of patient details and need to keep a record the date that patients have died. They have to be removed from the main table of patients, and their details/date of death saved separately.
Please can anyone advise me on the best way to go about this?