I think I figured it out..
Link the Databases so that the "Teacher for test A" in student Database is linked to the "Teacher ID" in the teacher Database. then add the field from the Teacher Database that I want to display into the student Database.
It worked for the first test I did. Now I have to do it for the other 30....Is there a better way of doing this? (by better I mean more efficient).
This question should have been asked in the FM Pro Forum where it would have been seen and responded to much more quickly.
There are two basice ways to "look up data" from one table to another. (I am assuming that you mean "table" when you say "database".)
One method you have already discovered is to establish a "dynamic link" where you just add the field from the related table.
Other method physically copy the data from a field in one table into a field in a related record in the other.
Both methods require a relationship and both have their uses.
Now I have to do it for the other 30
Don't see why you would need a different relationship for each test. If you make each test a separate record, a single relationship can be used to access all that are linked to the same teacher.
Note: I probably won't see any responses that you post here for about a week as that is about how often I check the FM Server forum...