looking up data from 2 tables

[Oscar Morejon]

i have 2 tables 1 has the codes of the classes per period
and per student the other table has who that code
(teacher name) it belongs to What i need to do is do
lookup the code and export out the to another table

 

[John Vinson]

i have 2 tables 1 has the codes of the classes per period
and per student the other table has who that code
(teacher name) it belongs to What i need to do is do
lookup the code and export out the to another table

Create a Query joining the two tables by class code.

It would rarely be necessary to "export out... to another table"; this
Query can be used directly as the recordsource of a Form or Report,
exported to text, or whatever.