AnsweredAssumed Answered

Look up? Connecting two Databases by seperate ID

Question asked by VeronicaChavez_1 on Mar 6, 2013
Latest reply on Mar 8, 2013 by philmodjunk

Title

Look up? Connecting two Databases by seperate ID

Your post

     Hi,

      

     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!

     -V

Outcomes