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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Newbie in Access
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! |
#2
|
|||
|
|||
Newbie in Access
wrote in message
oups.com... 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. 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. 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 he http://www.members.shaw.ca/AlbertKal...000000005.html Secondly, I need to somehow link the two tables together. 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/genacc...abasenorm.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. -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#3
|
|||
|
|||
Newbie in Access
Thanks for your help. I'll look into your given links. Yeah, I seem to
be the catch all I.T. specialist... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why is a French Spellchecker a "required" update for English speak | French Spellcheck Required? | General Discussion | 23 | April 26th, 2005 01:17 AM |
Access or Visual Studio? | Jerome | General Discussion | 61 | April 7th, 2005 07:14 PM |
starting access 97 | Edward Letendre | General Discussion | 2 | January 26th, 2005 02:15 AM |
Hiding Access | Mark A. Sam | Using Forms | 4 | December 1st, 2004 09:09 PM |
newbie. Access exits without confirm. | Van T. Dinh | New Users | 3 | September 20th, 2004 01:01 PM |