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