Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Unique ID

  Asked By: Ismael    Date: Nov 05    Category: Sharepoint    Views: 2336

It appears that the ID is not associated to a record ID. Is there a
way to create a unique ID for each record in a list?

What we're noticing (specifically in the Change Request List) ... if
we create a record, it is assigned an ID #. For sake of argument,
lets say it is ID #1. If we modify this record, save our changes;
modify it again - save the changes; and then create a new change
request...the record ID is #4. 2 & 3 are 'gone'.

Is there a way to create a field to have a record assigned a
sequential #? I understand that if we create a record, and it is
assigned an ID .... and then delete that record - the ID is lost



5 Answers Found

Answer #1    Answered By: Dean Neal     Answered On: Nov 05

Interesting, I didn't know that editing a list  item ate up ID numbers.
I'm going to have to check that out. If it does, I don't know of any
easy solution to this problem.

Answer #2    Answered By: Vincent Griffin     Answered On: Nov 05

I just tried this on an Event list  and I was unable to recreate the
problem. I'm not familiar with a "Change Request List", how did you
create it. Did you use WSS or SPS? If WSS, was it a Team Site or a
Meeting Workspace? Or is it perhaps a component of MPS?

Answer #3    Answered By: Antoine Barker     Answered On: Nov 05

I've noticed that this occurs in an Issues list. If you "update" the
item in an Issues list  with an ID of 1, then it actually creates a
second item in the list with an ID of 2 (or whatever the next available
number is). It does this so that the list can track the issue history.
You may notice that if you change  the issue several times, the issue
history will reflect all of these changes, pulling the data from all
previous instances of the issue.

The views for the Issues list are defined to only show the "current"
ones. The "current" ones are basically any items that have not been

I haven't seen this with any of the other list templates besides the
issues list.

Answer #4    Answered By: George Watson     Answered On: Nov 05

This is true. We're experiencing the same issue with our issues
list. What you've described makes sense. However, it is not a
solution to our problem. Do you know if / how to create  a unique  id
for individual records?

Answer #5    Answered By: Gabriel Patterson     Answered On: Nov 05

I had never noticed the ID change  but Bens description seems reasonable.
If you absolutely need the ID to stay static, can you create  your list
using something other than the Issues list  as the base. Or are you using
the Issue list's special built-in notification and graphical reporting

Didn't find what you were looking for? Find more on Unique ID Or get search suggestion and latest updates.