Okay...I think I'm getting a better understanding on how to build tables and relationships (database ones ) from reading these forums. So, as an example, I've learned that if I wanted to build a database of students with their info such as social security, address, classes they've taken along with the teachers they've had, I could build three tables -
1. Student info with a StudentID as the pk
2. Class info with a pk
3. Teacher info with a pk
then I would link the student info table and the class info table together by placing a field in the class info table such as "StudentNumber" and relating the pk from the student info table to the "StudentNumber" field in the classinfo table.
Right?
Hope that wasn't too confusing...
If I'm on the right track, it raises a question.
If I'm going to relate the student to the class with the linking field, I'm going to have to manually enter the number that is in the StudentID field on the Student info table into the "studentnumber" field in the class info table.
Right?
So..... what if I have a thousand students and a thousand classes? I have to know what a students ID is in order to enter it into the class info table to link the student to a particular class they have taken. Isn't that time consuming and error prone?
I must be missing something?????
Please someone shed some light on this total beginner.
Thank ya I hope my question and example wasn't too confusing. But, if you are tired and need something to put you to sleep, come read the post often
Thanks again!
1. Student info with a StudentID as the pk
2. Class info with a pk
3. Teacher info with a pk
then I would link the student info table and the class info table together by placing a field in the class info table such as "StudentNumber" and relating the pk from the student info table to the "StudentNumber" field in the classinfo table.
Right?
Hope that wasn't too confusing...
If I'm on the right track, it raises a question.
If I'm going to relate the student to the class with the linking field, I'm going to have to manually enter the number that is in the StudentID field on the Student info table into the "studentnumber" field in the class info table.
Right?
So..... what if I have a thousand students and a thousand classes? I have to know what a students ID is in order to enter it into the class info table to link the student to a particular class they have taken. Isn't that time consuming and error prone?
I must be missing something?????
Please someone shed some light on this total beginner.
Thank ya I hope my question and example wasn't too confusing. But, if you are tired and need something to put you to sleep, come read the post often
Thanks again!