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

>>Steve,
>>...I believe Mike is saying that the newID Table would have two fields:...TYPE and...NUMBER. The TYPE field would indicate...NEW or SALVAGED. There would probably only be one record of type NEW and multiple records of type SALVAGED.... Each user requests and gets a NEW ID number, and each time the NEW NUMBER record is incremented afterward.... Each time a user cancels their add, a record is added to the newID table with a SALVAGED type and the ID number that was canceled....

Why not just assign the ID number _only_ when a 'Save' is done? Then you won't have to worry about keeping track of unused numbers.

MHO,
Paul M.