One of the requirements is to have the application auto assign tickets to a support person based on the location of the incident. If the incident is at Site A in Kansas then the system needs to able to auto route to the Site A Support Group as wells auto assign a technician assigned to Site A. There can be many Sites in Kansas and each could have a unique support personnel, but there are also could be many sites that share the same support personnel - would be dependent on the proximity to each location.
Are there actually 1200+ support organizations and groups, no, but the requirement is still there and I see no other way to minimize the number of support groups and provide the requested functionality. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"