In this discussion https://community.esri.com/thread/181774-how-is-auto-increment-supposed-to-work a couple of ideas were tossed around, and Jake Skinner suggested using the AUTONUMBER method to sequentially increase a unique ID.
I just gave this method a try for the first time and it does not seem to work for me. I would like to deploy this method on the MASTER STREET NAME table within the LGIM and right now I'm working with a small test set of records. Prior to adding this method to the DyanmicValue table , I added a new field of long int type, calling it MASTERSTREETS_ID and calculating all the existing records to equal the OID, just to establish the numbering sequence. I then added a new record to the DynamicValue using the AUTONUMBER value method, setting the On Create field to TRUE and the On Change to false. According to http://solutions.arcgis.com/shared/help/attribute-assistant/tools/attribute-assistant-methods/#auton...
there is no Value Info needed, so I left it <NULL>.
However, when I add a new record, I get a value of 1 in the MASTERSTREETS_ID field. Not what I was hoping to get. I must be missing something but not sure what....
Solved! Go to Solution.
Joe,
I was able to find a bug with the autonumber and tables. I have made a fix to resolve this and it will be available in the next release.
The answer was right in front of me the whole time... In the other thread I reference, Mark Hotz provides a screen shot of his DynamicValues table. All I had to do is add the words "No Value" to the Value field; I was taking the online help literally....
Actually, if should be null. This method is not using the value info. We are using a few methods internally to determine the existing Max number in the field. Was your data a table or a feature class? Also, was it stored in a Enterprise GDB or a file GDB?
mmiller-esristaff; It's a table in a 10.3.1 File Geodatabase; it didn'twork for me until I put the words No Value in the Value Field. So it's supposed to work with <null>? I'll be back on site in couple of days and look closer at it then.
Joe,
I was able to find a bug with the autonumber and tables. I have made a fix to resolve this and it will be available in the next release.
I wondered about that after my last post.....
AMuise-esristaff Hey Allison- I noticed you marked Michael's answer as correct; any idea when the next release will be?
Sorry, I don't have a date for it yet.
We are targeting February for the next release.
Cool.