Two Tables, One Query, No Results

I am trying to build a query that allows me to enter data over two tables that are related. I'm using MS Access 97 if that makes a difference. For example

I have two tables like the following

Class
Class Id (auto number, primary key)
Class Name (text)
Class Teacher (text)
Class Room (text)

Student
Student ID (auto number. primary key)
Student Name (text)
Student Course (text)
Class Id (number, secondary key)

I tried creating a query that allowed data entry for the following fields

Student Name
Class Name

It first has the following error when trying to enter data in both the feilds;
The Microsoft Jet database engine can't find a record in the table 'Class' with key matching field(s)".

So i tried adding the record in the table class, but now i cant even see it in the query.

Any ideas?