If teachers only ever have one school to specify:
Schools::__pkSchoolID = Teachers::_fkSchoolID
If teachers, such as a Band teacher, can teach at multiple schools, you have a many to many relationship:
Schools::__pkSchoolID = Teacher_School::_fkSchoolID
Teachers::__TeacherID = Teacher_School::_fkTeacherID
If tihs notation is unfamiliar: Common Forum Relationship and Field Notations Explained
With this last setup, you typically place a portal to Teacher_School on a layout based on one of the other two tables to list either the schools at which a teacher teaches or the teachers that teach at a given school
Thank you very much Phil- This is very helpful. I am working through the steps.
In this case, it is the second example, where one band teacher teaches at multiple schools. But the database will be installed on each teacher's laptop, so do I need to include a table with the list of all teacher names? Can't they just enter their name in one field?
Finally, how would I construct the find request?
Thanks for your help.
There is not enough info about what you are trying to do for me to answer your questions with any real confidence that I am giving you good advice..
Will each teacher only record data about themselves and their teaching assignments?
If so, you have a one (teacher) to many (schools) relationship and you can use:
Teachers::__pkTeacherID = Schools::_fkTeacherID
Yes, that is correct. I'll work with that. Thank you!