I have a shapefile "ElementaryStudents" which has around 40,000 records in it. I also have a shapefile "ElementarySchools" which has 66 records in it. I want Network Analyst to calculate all of the routes from each student's residence to their school so that I can find the median distance for all students at each school. I have tried to do the field mapping and it wants to make each student's residence a stop on a route for all students assigned to a school. So, I end up with hundreds of stops for each school. I only want two stops. Student's residence as stop one and the assigned school as stop two. The result would have the number of routes equal to the number of elementary students.
I apologize if this is a redundant question, but I can't find a solution. I have tried so many combinations of field maps with no success.