P.S. You may have to make a form for table 2 first before you select Subform/Subreport from the Toolbox for the form for table 1.
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) > >
