Reports are based on tables and quryies using those tables. Your reports
should be based on a query using both tables if in fact your link between
the tables is as you say. If you start with John and add an encounter then
all data previosly colected from John should be linked to the event. You
seem (if your link/relationship is as you say) to understand relational data
but you are not using the power. If I have a zip code and related data I'll
never ever have to type in town again. When I type in that zip the records
are related and the persons address will have the town and zip already. In
other words, I have an encounter, Bill has been here before. I open a new
encounter record and select Bill. His DOB, Address, Sex, Previous encounter
records all show up on my form/subform as it is pulled from the orginal
encounter record and personnel record created. Search google for relational
database, normalizeation. Your working too hard to pull this together.
alexasha said:
My reports are based on encounter form. I have to have DOB on my report.
So
far, I copy DOB from Main database to Encounter. But I would like to have
an
easier solution.
Pete D. said:
If medical record number is linked to encounter TABLE by medical record
number then I would base the form on a query that already includes this
information. No reason to record the DOB in every encounter record as
you
already have it. Also if you correct the DOB later due to data error it
will be correct in all form views.
alexasha said:
I have two tables connected by Medical Record number.
I would like to pull DOB from Main table to Encounter form, that is
based
on
the encounter table.
I tried this
=DLookUp("DOB","[Main]","[Medical Record] = " &
Forms("Encounter_New")("[Medical Record]"))
but it does not work.
Please help.