A location (it’s a restaurant) can “serve” multiple locations. So, there’s a list of locations:
And a list of neighborhoods:
And a connecting table:
location_id (foreign key to LOCATION)
neighborhood_id (foreign key to NEIGHBORHOOD)
Then, the user is presented with a list (multiple select) of the neighborhoods that their location serves, and they can change them in the multiple select box, and this should be saved to the database. I guess I just need to know which event to handle, and it looks like I should delete all the records for that location in LOCATION_NEIGHBORHOOD, then insert the "new" ones.