Sounds like you need to use a sub-form. Basically, you create 2 tables. 1 table with the patient info: a unique identifier, name, birthdate, address, phone, etc. A 2nd table with the visit information: a unique identifier (this will be the same as in table 1 and the field name should be the same), date of visit, doctor name, order description, etc. This 2nd table will contain 1 record for each visit. Multiple visits for the same patient all will contain the same unique identifier that the patient has in table 1.
Create a form based on table 1. In Design View of the form for table 1, select the Subform//Subreport from the toolbox menu, and place it on your form. Right-click it and select Properties. When the Properties box appears, click the Data tab. For Source Object, select table 2. For Link Child Fields and Link Master Fields, type or select the field name of the unique identifier. Hope this helps and my memory was good. Gary At 04:21 AM 10/15/2007 +0000, you wrote: >I am trying to set up some tables in Acess to do the >following: > >The scenario is this: >A person visits the hospital. On the first visit they >are assigned a medical record number that is their >unique identifier. (sort of like a social security >number) > >Each time after that they come in, they get a visit >number so they can have many visit numbers depending >on how much they come in. > >Also the doctors can order one, many or not test done >so the order field could repeat. > >I have the folling other fields that i will put in the >table >patient name >birthdate >date of the first visit >visit date (date of a particular visit) >doctor (the doc that saw them at the visit) >order description (what they had done ex-blood work) > >
