Newbie in Access

D

dperry

I'm extremely new to Access, so I'm sorry for the stupid questions.

First off, I need to know how to add a second table to a form once the
form has already been created... I've searched high and low to do this
and cannot seem to do it. I really dont want to recreate the form
because I know I'm going to end up needing to add a 3rd table and I
dont want to create a new one again.

Secondly, I need to somehow link the two tables together. The first
table is a person and his contact information. The second is a table
for his family members, including himself, that are or are not allergic
to certain medications.

Thirdly, I need to to figure out how I can have an 'entering field' for
the second table on the form. Meaning, I would like to have a single
text box that when I enter information in it, it will clear after I hit
an 'enter information button' but populate a list to the right. And
from that list I would like to be able to go back to that list and
edited it if needed... I think this is the most challanging thing I'm
asking..

Thank you sooo much for your help!
 
A

Albert D.Kallal

I'm extremely new to Access, so I'm sorry for the stupid questions.

First off, I need to know how to add a second table to a form once the
form has already been created... I've searched high and low to do this
and cannot seem to do it.
Click to expand...

The reason why you can't do it is because you can't really add a 2nd table
to a form.

What you do is create what is called a sub-form. A sub form is simply a
standard form that you create in ms-access. You would base this 2nd form on
your 2nd table. After you are done creating this form, you then go back to
the original form, and then place the sub-form INSIDE of the first form.

This is how you normally deal with multiple tables in ms-access.

I really dont want to recreate the form
because I know I'm going to end up needing to add a 3rd table and I
dont want to create a new one again.
Click to expand...

Again...for the 3rd table...you would also again exit..and create the 3
form...and again use the above sub form concept.

I talk about sub-form here:
http://www.members.shaw.ca/AlbertKallal/Articles/fog0000000005.html
Secondly, I need to somehow link the two tables together.
Click to expand...

You will have to learn how to setup tables in the table designer, and learn
about how you relate tables to each other. In fact, you need to learn this
BEFORE you create the above sub-forms. So, you need to get your table
designs, and relations setup.

Here is a good article on how this works:

ACC2002: Database Normalization Basics
http://support.microsoft.com/?id=283878

Database Normalization Tips by Luke Chung
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html

Data Normalization Fundamentals by Luke Chung
http://www.fmsinc.com/tpapers/datanorm/index.html

324613 - Support WebCast: Database Normalization Basics
http://support.microsoft.com/?id=324613

And, since you are new to this...you might consider grabbing a few books on
this. Remember, while you can stumble your way through learning word, or
Excel, you will NOT be able to do this with ms-access...as it is a MAJOR
step up in terms of complexity, and what you need to learn.
 
D

dperry

Thanks for your help. I'll look into your given links. Yeah, I seem to
be the catch all I.T. specialist...
 
Top