>Why does an auto increment field sometimes skip a number? It seems to work properly when adding a series of records while in browse append mode but after exiting and coming back it will skip the next number and increment the first record by 2. Is this normal?


I've not used AUTOINC myself, but is it possible that you TABLEREVERT() a record somewhere along the way?

good luck