PC Review


Reply
Thread Tools Rate Thread

Connect Tables? I have too many fields

 
 
New Member
Join Date: Jun 2012
Posts: 1
 
      19th Jun 2012
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!!
 
Reply With Quote
 
 
 
 
New Member
Join Date: Jan 2013
Posts: 3
 
      23rd Jan 2013
Quote:
Originally Posted by kkellylovell View Post
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!!
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Too many many-to-many? Huber57 Microsoft Access 10 12th Feb 2008 09:11 PM
How many one to many relationships are too many? Debra Farnham Microsoft Access Database Table Design 9 25th Oct 2006 03:40 PM
mailing label report generates too many pages & too many copies =?Utf-8?B?U2NvdHQgQmlsbGluZ3M=?= Microsoft Access Reports 7 25th Jul 2006 09:13 PM
I have too many columns and rows, so it prints too many pages. =?Utf-8?B?SGVscCBJIGFtIG5ldyB0byBhbGwgdGhpcw==?= Microsoft Excel New Users 2 24th Jul 2005 04:45 AM
Re: 1 to many - many to many - many to 1 Miha Markic Microsoft ADO .NET 3 23rd Jan 2004 06:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:25 AM.