>In Visual FoxPro 6, I have used a default value (with a function that gets a value from a table), and values are skipped mainly under the following circumstance: the user adds a record, then decides not to save (and presses the "Undo" button in the form). In this case, the number was already used, and won't be assigned again.

Or get the new PK only when the actual save to DB is asked for -
even if it gets more complicated if child records need the PK as FK...

regards

thomas