1 Reply Latest reply on Apr 2, 2010 11:30 AM by philmodjunk

    Corrupt Records

    nolak37

      Title

      Corrupt Records

      Post

      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

       

      FMPA11