A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Creating database and wish to automate



 
 
Thread Tools Display Modes
  #1  
Old December 15th, 2008, 04:08 PM posted to microsoft.public.access.tablesdbdesign
Theresa
external usenet poster
 
Posts: 176
Default Creating database and wish to automate

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
  #2  
Old December 15th, 2008, 04:21 PM posted to microsoft.public.access.tablesdbdesign
Roger Carlson
external usenet poster
 
Posts: 824
Default Creating database and wish to automate

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



  #3  
Old December 15th, 2008, 05:08 PM posted to microsoft.public.access.tablesdbdesign
Theresa
external usenet poster
 
Posts: 176
Default Creating database and wish to automate

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




  #4  
Old December 15th, 2008, 07:08 PM posted to microsoft.public.access.tablesdbdesign
Bob Waggoner[_2_]
external usenet poster
 
Posts: 80
Default Creating database and wish to automate

Theresa, because access is a relational database, you can create forms and
reports from more than one table. When you access the data, do you want to
access it on a form or report?The way you link those tables (by your key MR#)
allows you to draw information from both tables. You may simply want to
create a subform or subreport that uses the data from both tables.

Table 1 (key MR#)
Table 2 (foreign key MR#)


"Theresa" wrote:

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




  #5  
Old December 15th, 2008, 11:07 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Creating database and wish to automate

On Mon, 15 Dec 2008 08:08:04 -0800, Theresa
wrote:

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.


Well, you're not taking full advantage of the tools that Access provides!

As Roger says, you should NOT store the name or other demographics redundantly
in any second table. Relational databases use the "Grandmother's Pantry
Principle": "A place - ONE place! - for everything, everything in its place".

I would use a Form to enter the data. You should almost certainly NOT make the
user type in a MR# (and then slap their hand if they make a mistake); instead
they should *select* the MR# from a Combo Box. You could also (or instead)
have a combo box displaying the last (and first, and MR#) name, but storing
the MR# in your table. With the default autocomplete feature turned on, they
can start to type the number or name and it will jump to the first value
starting with what they type. The Combo Box can also display the patient's
name; or, you can put textboxes on the form with control sources like

=comboboxname.Column(n)

where n is the zero-based index of the field you want to display from the
combo's row source query.

--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.