Re: Creating database and wish to automate

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Mon, 15 Dec 2008 08:08:04 -0800, Theresa
<Theresa@xxxxxxxxxxxxxxxxxxxxxxxxx> 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]
.

Relevant Pages

  • Re: Problem with Nested table
    ... However, since each visit is unique to each patient, there was never more ... query which joins the visits with the appropriate demographics, ... I have a problem during the application of a Decision Tree. ...
    (microsoft.public.sqlserver.datamining)
  • Portals, Table Occurrences and so on
    ... I have some table all related to the demographics (patient names, ... exams were done and when. ... I would like to go further and have a summary area in the layout ...
    (comp.databases.filemaker)
  • Problem with Nested table
    ... How can I add this calculated column into my table in the DSV? ... uniquely identifies a patient visit. ... query which joins the visits with the appropriate demographics, ... I have a problem during the application of a Decision Tree. ...
    (microsoft.public.sqlserver.datamining)
  • Re: Problem with Nested table
    ... However, since each visit is unique to each patient, there was never more ... query which joins the visits with the appropriate demographics, ... I have a problem during the application of a Decision Tree. ...
    (microsoft.public.sqlserver.datamining)
  • Re: Creating a new form everytime a contact is made
    ... subform to DISPLAY the visit data. ... This author may have received products and services mentioned ... Now the staff would like to show multiple contacts for that same patient ...
    (microsoft.public.access.forms)