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