I use ArcGIS 10.1 for Desktop.
I have a polygon Feature Class with municipalities.
In a non-geographic table, I have these same municipalities, with an additional contract information.
The contract name is stored as a String in a field. Each municipality can have either zero, one or more contracts. In the table it appears as often as it has the information, i.e. a municipality with three contracts appears three times in my table.
At the end, I need a dissolved polygon for each contract where every munipality of the specific contract is within. These polygons must be overlapping when a municipality has more than one contract.
Does anyone have any idea how to to this, preferably in ModelBuilder, that another user could reuse it, only pointing where he has the existing table and feature class?