AnsweredAssumed Answered

How to store deleted records

Question asked by dsimonson on Jan 8, 2015
Latest reply on Jan 15, 2015 by dsimonson


How to store deleted records


I am continuing to work on my electronic anesthesia record.  Here is a problem.  I have been very good about separating out fields into tables and tying them all together via key fields.  However, when a user wants to delete a patient record, they usually want to archive it rather than delete it completely, and I now have the problem of moving all of the data for that deleted patient, stored in about 50 different tables, into something that I can use to reconstruct the record. 

What is the best technique to do that?  Should I create a layout starting with PATIENT, and put all of the related fields on it (a bazillion), and then export it to a deleted or archived records file?  


Dan Simonson, CRNA, MHPA
2607 S. Manito Blvd.
Spokane, WA 99203

H. (509) 747-0819
C. (509) 981-6274