displaying multiple records for one patient

[spud]

I have a table that has patient records. Each patient has one Medical Record
Number (column A), but each subsequent visit they are assigned an Encounter
number (Column B).

I'd like a form to display the Medical Record Number at the top, then below,
each encounter number and its related data.

New to Access, but have a brain freeze of how to set this up..any help is
appreciated.

 

[ghetto_banjo]

You could use a subform that has all Encounter Numbers for matching
Medical Record number on the main form. I believe the subform wizard
can walk you through setting that up automatically.

 

[John W. Vinson]

I have a table that has patient records. Each patient has one Medical Record
Number (column A), but each subsequent visit they are assigned an Encounter
number (Column B).

I'd like a form to display the Medical Record Number at the top, then below,
each encounter number and its related data.

New to Access, but have a brain freeze of how to set this up..any help is
appreciated.

A better table design would be to have one Patients table with static
biographical information (name, contact info, etc.), with the Medical Record
Number as the primary key; related one to many to an Encounters table, with a
Medical Record Number as a foreign key and an encounter number, perhaps as a
joint two field primary key. You could use a Form based on the patients table
with a Subform based on the Encounters table to display and edit this data.

I hope you're aware of the very stringent patient privacy and data security
issues for medical records data under the HIPAA law. Check it out before you
get too deep; it can be argued that Access has inadequate security for such
data storage.