Brief snapshot of what Im trying to do:

My application is used as a job application.  Candidates submit their info and resume via a form.  An email alert is sent to the manager assigned to that location

We have 100+ locations, each with different managers, each manager with their own email address.  The problem that I encounter is that if a manager leaves the company, or is assigned another group or locations I have to edit my script to make those changes.  Obviously this is an easy way to make errors.

If I understand correctly I can solve this by creating another application with Manager Name, Manager Email, and Locations.

I have done so.  Manager names are in a drop down menu, email addresses are in a drop down menu, locations are in a multi-select check box.

This way I select the manager, select their email address, then check off all of their locations.

When its time to make a change I can just go into the View and make needed changes.

My BIG question is how do I connect this data with my application, so that it pulls the manager and email based on location so that email alerts are sent?