To find skipped numbers is pretty straight forward but you need to clarify what you mean by 'fill in new data'.
At the moment your question is as wide as 'is there a way to get from London to New York?'. Explain exactly what you are trying to do in simple English.
ok,
the example of my question is like this
I have a database such as:
0001, 0002, 0003, 0004, 0005, 0006, 0007 and so on
and then I delete the no 0005
so the result after I delete the 0005, my database should be like this:
0001, 0002, 0003, 0004, 0006, 0007
and if I want to add a new record, I wanted the new record to fill the skip number, which is in this case is 0005
is there anyway to do that?
thanks before and sorry if I was not explaining my question with more detail