Resetting Unique ID's

[Kevin Cheesman]

I'm using the Auto-enter serial number for most of my tables, but if I want to abandon an entry, how do I reset the number in code?

[JesseSFR]

You can change your serial number to only increment on commit and that would get your id "back" because it's never assigned one in the first place. Otherwise you can use the set next serial value script step to set the fields serial number to something different but I wouldn't recommend that approach.

What is your goal?

[Vaughan]

If the increment on commit is selected, it's possible to get serial numbers out of order. Two users create new records; the second new record gets committed first so it gets the earlier serial number.