I have a solution with File A which records visits to a doctor's office. So
if a patient comes in on 9/12/99 with a diagnosis of flu we record that
visit with a self-generating serial number. If the same patient comes in
with a different problem - say a skin rash - they get another new record
with a different serial number.
The question I have is - if the patient comes in for a second or follow-up
visit that is related to the flu original visit - how can I create a subset
of all visits (original and followup) that are related to like visits (all
flu visits; all skin rash visits, etc) without creating a second related
file (which is what we do now).
Is it possible to create a portal that meets these needs and if so how would
you set it up?
Any help would be greatly appreciated!!