New answers tagged cascading
I would suggest putting the districts and their schools in a Term Set and use a Managed Metadata column.
You can use SPServices Cascaded Dropdown functionality Or you can modify list forms via InfoPath and achieve cascaded dropdowns, as shown in the following post: How to create cascading dropdowns in InfoPath [[The example relates to SharePoint 2010, but its the same for SharePoint 2013.]] I hope you already know about Lookup columns, and know that Schools ...
Top 50 recent answers are included