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.

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.

On Mon, 16 Feb 2009 10:09:01 -0800, spud <(E-Mail Removed)>
wrote:

>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.
--

John W. Vinson [MVP]