Newbie question re setting up relationships
I'm sure there is an easy way to do this, but after hours of combing through tutorials and posts, I'm still stuck.
I have a database of student info from a number of schools. I often use scripts to filter and display students from only one school. Easy.
Now I am modifying my solution so that it can be used districtwide. So I need a way for each teacher to enter their schools and then perform finds in the same way. So I guess I set up a table defining their schools (School #1=Washington, and so on), and then link it somehow so when teacher A performs a fine request for her "school #1" it matches records from Washington school, and when teacher B selects his "school #1" it shows students from Lincoln School. And so on.
I'd much appreciate a quick step-by-step.