topic Re: Auto number column other than objectID in Data Management Questions https://community.esri.com/t5/data-management-questions/auto-number-column-other-than-objectid/m-p/174043#M9836 <HTML><HEAD></HEAD><BODY><SPAN>Did you ever find an answer to your problem?&nbsp; I built an MS Access database for our department and I linked the addresses to our County 911 addresses in their ESRI geodatabase.&nbsp; I built a geolocator with one field (my address ID and 911's Object ID) so that when I geolocated the addresses, I always got a 100% match.&nbsp; </SPAN><BR /><BR /><SPAN>Everything worked perfect until I got their updated version and their Object IDs changed.&nbsp; I would like to use an auto number that will not change.&nbsp; I still can't figure out why the Object IDs do not stay with their original records.</SPAN></BODY></HTML> Wed, 16 Mar 2011 19:37:50 GMT RUSSMILTON 2011-03-16T19:37:50Z Auto number column other than objectID https://community.esri.com/t5/data-management-questions/auto-number-column-other-than-objectid/m-p/174042#M9835 <HTML><HEAD></HEAD><BODY><SPAN>I have ArcSDE 10 with sql server 2008 sp2. </SPAN><BR /><SPAN>I want to create a column in couple tables where it will be auto increment ( other than objectid)</SPAN><BR /><SPAN>When use would add new point or line on the map they should&nbsp; not have to think about the id , it should be auto incremented. does anyone have solution for this...</SPAN><BR /><BR /><SPAN>thanks</SPAN><BR /><SPAN>Tony</SPAN></BODY></HTML> Fri, 18 Feb 2011 16:30:41 GMT https://community.esri.com/t5/data-management-questions/auto-number-column-other-than-objectid/m-p/174042#M9835 Tonyj 2011-02-18T16:30:41Z Re: Auto number column other than objectID https://community.esri.com/t5/data-management-questions/auto-number-column-other-than-objectid/m-p/174043#M9836 <HTML><HEAD></HEAD><BODY><SPAN>Did you ever find an answer to your problem?&nbsp; I built an MS Access database for our department and I linked the addresses to our County 911 addresses in their ESRI geodatabase.&nbsp; I built a geolocator with one field (my address ID and 911's Object ID) so that when I geolocated the addresses, I always got a 100% match.&nbsp; </SPAN><BR /><BR /><SPAN>Everything worked perfect until I got their updated version and their Object IDs changed.&nbsp; I would like to use an auto number that will not change.&nbsp; I still can't figure out why the Object IDs do not stay with their original records.</SPAN></BODY></HTML> Wed, 16 Mar 2011 19:37:50 GMT https://community.esri.com/t5/data-management-questions/auto-number-column-other-than-objectid/m-p/174043#M9836 RUSSMILTON 2011-03-16T19:37:50Z