AnsweredAssumed Answered

Newbie question re setting up relationships

Question asked by DaveMartyn on Dec 20, 2012
Latest reply on Dec 20, 2012 by DaveMartyn


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.

     Thank you!