Thank you so much. I am looking for a way that when you go to the Hospital
admission form/table and type in a mr # you can verify the patients name and
make sure the patient has a record in the demographics table. any suggestions
on ow to accomplish that. I know this is pretty basic but I appreciate your
time. Maybe when going into the Hospital adimssin form, the first and last
name are placed on the form somehow and not stored as additional data. Also,
I would like to look patient up by last name to complet the hospitaization
form. I maybe approaching this all wrong.

Thank you,
Theresa


"Roger Carlson" wrote:

You shouldn't do that. As long as you have the MR# linking the two tables,
you can join them any time you need the patient name.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Theresa" wrote in message
...
I have been working on a database (for a really long time) and getting
nowhere. I am stuck on how to get data in a field from one table into
another. Specifically- I have a table listing patient demographics in
separate fields (MR#(Key), Last Name, Address...). The next step is to go
to
a table (Relationship is the MR# field) that l list each hospital episode
data (admission date, diagnosis, physician...). There can be many hospital
records for each patient. I am currently stuck at the point where I would
like to enter the MR# on the hospitalization table and the last name and
first name from the demographics table automatically fills in when the MR#
match. As soon as I get this down, I am sure I will come up with another
issue, but I have to start somewhere. Thanks, Theresa