Look up? Connecting two Databases by seperate ID
I have two seperate Databases, one that holds student information and one that holds teacher information.
The student database holds test information for students with a unique 6 digit student ID as well as a teacher associated with each test.
The teacher database holds test information for teachers with a unique 3 digit teacher ID.
I need this:
In the Student Database:
"Student 000000" "Student test A results" with "Teacher 000" and "Teacher 000 Test A results" "Student test B results" with "Teacher 001" and "Teacher 001 Test B results" .
i.e. a student took test A with Teacher 000 and test B with Teacher 001. I need to display teacher 000 results and teacher 001 results with this student's information.
How do I link the two Databases?
(How do I tell it to look for 001 or 002 and display that information? Is it a look up? Calculated value? or just a reference??)
Thank you sooo much!