Connect Tables? I have too many fields

Discussion in 'Microsoft Access Database Table Design' started by kkellylovell, Jun 19, 2012.

  1. kkellylovell

    kkellylovell

    Joined:
    Jun 19, 2012
    Messages:
    1
    Likes Received:
    0
    Hello,

    I am setting up a Database for a school that enrolls students temporarily until they can go back to their original school. Many of these students come back to us again and again, so we would like to keep all of their enrollment history together in one record.
    So, I have set up a Form that feeds into the Student table. I have the StudentID number, Name, Age, Grade, Address and so on and so on and on and on. But where I am running into the problem is that on the form, I want 10 enrollment histories for each student that include address, grade, enrollment date, leaving date, teacher, classes, and so on. So, when the student comes back to us, we can enter in and still keep track of all the students' information from the first time they enrolled, and the second time enrolled, and third and so on. After all said and done, I need about 400 fields for each student.
    I thought about making it to where we could add a new record every time a student comes back and re-enrolls, but that means that student would get a new StudentID. For many reasons, that is not a good thing. :)
    So, is there a way to get all the fields I need for each student?

    Thank you!!
     
    kkellylovell, Jun 19, 2012
    #1
    1. Advertisements

  2. kkellylovell

    Dave_R

    Joined:
    Jan 22, 2013
    Messages:
    3
    Likes Received:
    0
    You would be better off making a separate table for enrollment history and using the StudentID as a foreign key to link to the Student table. You can then have as many history records as you want for each student rather than a 10 record limit. You would also cut down the number of fields you need too. This way the students ID number would not change. You could also add a field to the student table to make a student inactive.
     
    Dave_R, Jan 23, 2013
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Many-Many junction table using tables with multiple key fields

    Guest, Mar 17, 2006, in forum: Microsoft Access Database Table Design
    Replies:
    5
    Views:
    316
    Guest
    Mar 19, 2006
  2. erick-flores

    Problem designing tables: Too many fields

    erick-flores, Aug 8, 2006, in forum: Microsoft Access Database Table Design
    Replies:
    20
    Views:
    750
    erick-flores
    Aug 10, 2006
  3. Debra Farnham

    How many one to many relationships are too many?

    Debra Farnham, Oct 24, 2006, in forum: Microsoft Access Database Table Design
    Replies:
    9
    Views:
    445
    Jamie Collins
    Oct 25, 2006
  4. Hal

    Relating Multiple tables with one-to-many & many-to-many relations

    Hal, May 12, 2009, in forum: Microsoft Access Database Table Design
    Replies:
    12
    Views:
    377
  5. Hal

    Relating Multiple tables with one-to-many & many-to-many relations

    Hal, May 12, 2009, in forum: Microsoft Access Database Table Design
    Replies:
    0
    Views:
    223
Loading...

Share This Page