We have a single list within a WSS site. What we need is a unique icremental ID to be generated each time a new list item is created. The ID number can have no gaps and can never change once created. We tried using the ID field which works great until someone updates a list item and then the ID also updates and there is a gap where the old ID was. We also tried doing some creative stuff with create date and calculated fields, but nothing has worked so far.
We are operating in a locked down environment, no code and no workflows. I found a few code based solutions, and a workflow based solution but as said we cannot use either.
Does anyone have any ideas on how to accomplish this? Is it even possible?