topic Re: Any ideas for a key for a dynamic table? in Business Questions

Any ideas for a key for a dynamic table?

laurenmckinney1 — Tue, 11 Apr 2017 22:41:57 GMT

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.

Re: Any ideas for a key for a dynamic table?

JoeBorgione — Tue, 11 Apr 2017 23:36:03 GMT

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

Re: Any ideas for a key for a dynamic table?

laurenmckinney1 — Tue, 25 Apr 2017 18:01:46 GMT

Thank you!