AnsweredAssumed Answered

Attribute Assistant Autonumber Method

Question asked by jborgion Champion on Aug 25, 2016
Latest reply on Oct 21, 2016 by jborgion

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/#autonumber

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....

 

 

 

Jake Skinner

Mark Hotz

Michael Miller

Outcomes