AnsweredAssumed Answered

Corrupt Records

Question asked by nolak37 on Apr 2, 2010
Latest reply on Apr 2, 2010 by philmodjunk


Corrupt Records


Hello Again,


So I have a file that holds medical record information and it is made up of something like 22 tables

these hold different types of information and are all related by Patient ID numbers that are auto populated when a new record is created.


Long story short, in 3 different ocations now we have ran into a small problem where we create a new record for a patient and create a new medical visit, maybe order some lab work or xray or something and when the patient returns for the results in 2-3 days we search the patients name and a record appears with "?" in every field.


This is not good for many reasons and i was wondering if this is something that happens frequently and what i can do to prevent it.


Any help is greatly appreciated.

Thanks in advance