 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / November 2005Getting Two Existing Tables to Relate in a Form.
I have a form that displays records from two tables. The first table is named Students. The second table is named Classes. At the top of the form the Student table information displays. At the bottom of the form the classes the student has taken should display. However, when I go to the next student in the form the classes do not change at the bottom. There's no common key between the two tables so I know that's the problem. But since these tables (which have many records) and form already exist how do I solve this problem? Thank you in advance! Do you have a third table where you specify which classes each student has taken? This is a Many-to-Many relationship and it requires at least three tables.  SignatureRick B >I have a form that displays records from two tables. The first table is >named [quoted text clipped - 13 lines] > > Thank you in advance! No Rick I do not have a third table. I'm wondering if creating an AutoNumber in each of the two tables then making it the Primary Key for them to link on. Sounds too simple though and I'm new to this... > Do you have a third table where you specify which classes each student has > taken? This is a Many-to-Many relationship and it requires at least three [quoted text clipped - 17 lines] > > > > Thank you in advance! You are losing me. You have a list of people in one table. You have a list of available classes in another table. Now, you need a new table to tell it which people took which class. John might have taken PSYC2301 in Fall of 2005 and ENG1301 in Spring of 2005. Phil might have taken PSYCH23020 in Fall of 2005 and ENGL1301 and MATH1301 in Spring of 2005. Etc. You have to have a third table in this case, unless your structure is flawed in some way. SignatureRick B > No Rick I do not have a third table. I'm wondering if creating an > AutoNumber [quoted text clipped - 26 lines] >> > >> > Thank you in advance! Thanks Rick...your explanation makes perfect sense. > You are losing me. > [quoted text clipped - 40 lines] > >> > > >> > Thank you in advance! Table1 StudentNumber FirstName LastName SS# etc. Table2 ClassNumber ClassName etc. Table3 StudentNumber ClassNumber DateCompleted ClassGrade SignatureRick B > No Rick I do not have a third table. I'm wondering if creating an > AutoNumber [quoted text clipped - 26 lines] >> > >> > Thank you in advance! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.