yes, that's the problem. what I want is a PO number that increments one time, then stays at that number until I save something to the record with that number, so there are no holes (if my definition of holes is the same as yours).


>Most PK generators don't allow you to go back once they've assigned a number, because of issues when dealing with multiple users, it can create holes, are you sure that's not the problem?
>
>>I have an incremental number generator (primary key) that I use for a P.O. number. I'm using Optimistic Buffering. The problem is that when I simply exit without saving and enter again, it increments again. The buffer doesn't clear until I close foxpro. what command can i use in the exit click event that will CLEAR THE BUFFER?