>If you are concerned about making the ID numbers tight with no gaps, then >structure your new Id table like this: > >TYPE NUMBER > >NEW 000564 >SALVAGE 000563 > >When you go to add a new ID, FIRST search for a SALVAGE type...If found() Lock >it, use it, deleted it. If its NOT found(), search for a NEW type...lock it, >increment it, unlock it. > >And no matter what...If the save falls through, Insert the unused ID number >into the table as a SALVAGE type. > >In otherwards...The salvage type will always hold FAILED ID numbers...and you >will always use them first. Mike, What would happen if you have say three users all start adding a new record and all three end up cancelling the adds? I don't see how your structure would support multiple IDs to salvage. Am I missing something?