I have a field with an Auto Entry Serial Number. The field is a text field that uses a number with leading zero's, i.e. "00142" and increases by "1" with each new record request.I need to create a script such that when a record is deleted, the serial number automatically gets reset so the next new record continues where it was left. My trys using the "Setfield" script and adding 1 converts the serial number to a number and I lose the leading zeros.

Thank you for your help.

DT

if you do an advanced search in these forums for +serial +reset you should get a tons of posts on this subject.

As for your issue of padding the number with zeros, see this thread

http://www.fmforums.com/forum/showtopic.php?tid/194864

This recent thread should be also helpful:

http://www.fmforums.com/forum/showtopic.php?tid/194889/

DT,

You could try this.

Show All Records Go to Record/Request/Page [Last]

// I set a global field with the serial number. (or you can use a variable)

Set Next Serial Value [your serial;00 & global or variable +1]

Commit Records

Hope it helps.

Dean

Edited May 1, 200817 yr by Guest