title: Display students from table who belong to a school
body: <p>I have a list of schools I am displaying. In a dropdown for each school I want to only display students from student table whose fk is equal to pk in depart table. Depart Table is has fk school_schoolId. There are many schools. e.g. In student table - studentId=1, depart_departId=4, school_schoolId = 4. 
       In school table - schoolId=4
  Therefore student 1 will be listed under school 4.</p>
  
  <pre><code>@foreach (var item in Model.School)
  {
     @:&lt;tr style="background-color:grey;-moz-border-radius: 15px;border-radius: 15px;"&gt;           
        &lt;td class="accordion" style="width: 50%;padding-left: 10px;text-align: left;"&gt;
           &lt;a href="#"&gt;@item.Name&lt;/a&gt;
           &lt;div style="font-size:10px;"&gt;
              @foreach (var student in Model.students)
              {         
                 &lt;div style="background-color:grey;width:100%;padding-top:10px; margin-bottom:10px"&gt;
                    &lt;span style="margin-left:8%; text-align: center"&gt;@student.Name&lt;/span&gt;
                 &lt;/div&gt;
              }
           &lt;/div&gt;                                                                               
        &lt;/td&gt;
     @:&lt;/tr&gt;                                               
  }
  </code></pre>