As a service company, I need a way in insure dispatching is done properly.I was thinking of "Zones" based on Zipcodes.(EX 29653 = SC01). My Zipcodes and Zones are both in a dropdowns on the Equipment Form. As new equipment gets added to the database, when a Zipcode is added, the Zone also gets added automatically. I have tried using the If statement;

if (input.zipcode == 29653)

{

      Zone = "SC01"

}

But that would mean I would have a great deal of "If Statements"

I then added the Zone as a Dropdown to my Zipcode form. Once I get this part completed, I wanted to have it when the Dispatcher sends out a service call to my technician, as the data is entered, the app looks at the "Zone" and shows a list of Technicians in that area.

Any Ideas on this procedure?