How to calculate results 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 ?


a sample Db TEACHER.zip

[June7]

Use form/subform arrangement.

Main form bound to Teacher.
Subform bound to Observation.

Filter the main form.

Or build a report that has a RecordSource that joins the two tables.

BTW, Observation should not have teacher name, it should have teacher ID, as foreign key.

This is basic Access functionality and Access Help has guidance.