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