how to link a record in a table to another table?

[ralph1009]

hello guys.. i would like to ask that it is possible to link a record from a table
to another table?

example, in table "Student" with data fields of "Student Number" and "StudentName".
in the "Student" table with the record of 09-30170(student number), John Cruz(Student name) and 09-30171(student number), Joanna Lee(student name)

how can i link the record of 09-30170 John Cruz in the "Student" table to a "09-30170 John Cruz Grades" table as well as the record of 09-30171 Joanna Lee in the "Student" Table to a "09-30171 Joanna Lee" table?

im using MS Access 2007. hoping for your kind replies..

 

[Mr. B]

Linking this type of information is exactly what relational databases do best.

From your post it appears that you may have a table for each students grades.

What you should have is your Student table with the primary key and a Studen Grades table with one primary key field (autoNumber) and a number (long integer) field that would be Foreign Key field that would link a record in the Student table with a record in the Student Grades table.

 

[ralph1009]

Linking this type of information is exactly what relational databases do best.

From your post it appears that you may have a table for each students grades.

What you should have is your Student table with the primary key and a Studen Grades table with one primary key field (autoNumber) and a number (long integer) field that would be Foreign Key field that would link a record in the Student table with a record in the Student Grades table.

Thanks for your reply Mr.B but I can't fully understand your instruction. Can you give me a step by step process?

Well here's the scenario:

Student Table
Student_Number Field (I set this one as Primary key)
Student_Name
ex.
09-30170 John Cruz
09-30171 Joanna Lee

I want to link these following records into a separate table where the record of 09-30170 John Cruz will be linked on 09-30170 John Cruz's Grade Table where the grades of John Cruz are listed and the record of 09-30171 Joanna Lee will be linked on 09-30171 Joanna Lee's Grade Table where the grades of Joanna Lee is listed.

Can you give me detailed instructions sir? Thank you for your kind reply.