Question help in calculations from two tables

[Nokia N93]

Hello

i need your help in this one, i have a small school with number of teachers, every teacher has a specific number of observations in the semester, i need a small project that when i query a bout a teacher, a form appearing with his name and the remaining hours of observation

what i did is i made two tables
teacher (id, name, total number of observations in semester)
observation( Oid, name of teacher, date and time of observation, remaining observations)
-- i dont know if i have to make a counter or what !!--

Now what i need to do is a form
when i enter the id of the teacher, it shows automatically the name of the teacher, and the number of remaining observations

How can i join the two tables and show the results ?

 

[Nokia N93]

Hi, the following is an attached sample , can you look at it

 

[Pat Hartman]

In the observation table you need TeacherID rather than TeacherName. That will allow you to join the two tables. If this project will cover more than one semester, you might want to add a semester indicator to the observation table.

For the RecordSource of the form use a query that joins the two tables. That way you can choose columns from both tables.