Every time I create a certain feature, I have to assign it an ID for the next available number. This is complicated by the presence of several markets that can have the same ID between them. The configuration is this:
Feature type - market - UniqueID
or (examples)
XY - NYC - 2112
XY - BOS - 2113
What I would like to do is create a rule that would create the next available number in the NYC market (assumably 2113). Or if I create a feature in the BOS market, it will go to 2114. Any thoughts on how to do this? All I can figure out is lat/lon and grabbing attributes from a source layer.