Any ideas for a key for a dynamic table?

879
2
04-11-2017 03:41 PM
laurenmckinney1
New Contributor

I am working on table where the rows are subject to change (either being removed or added). I am taking a project list and turning it into a map. The only hang up is that the list is still in flux - with some rows being removed and some being added. Is there a methodology for creating a key that would support a dynamic table? For example, Project number 33 could be deleting, creating an odd hole in my data. I am aware that I could use field calculator to change all the other ID, but I was hoping there is a more efficient way to fix this problem.

Thank you so much! My apologies if this is a bit confusing.

0 Kudos
2 Replies
JoeBorgione
MVP Emeritus

Take a look at my reply in https://community.esri.com/thread/193158-objectid-used-in-relates-now-okay 

If it were me, I'd learn to live with the 'holes'.  The easiest thing to do is retire the identifier when you delete a record. Poof.  It's gone.  You stand to lose your mind trying to keep it sequential with adds and deletes...

That should just about do it....
laurenmckinney1
New Contributor

Thank you! 

0 Kudos