How do I reset the serial number counter back to one. I mean, is there a script or build-in function that does this?

Thanks.

j

The following script will do it:

code:

---

# Resets SerialNoField Serial numbers to 1

Show all records

New Record/Request

Omit Record

Show Omitted

# go to a layout that has the SerialNoField on it (with field entry enabled)

Go to Layout [serNoWorkingLayout]

Replace [serialNoField, Replace data: Serial numbers,

Custom Values, Initial Serial number value:0, Increment Value:1,

Update entry options][no dialog]

Delete Record/Request

Show all records

Go to Layout [Original Layout]

---

Warning, if you have other serial number fields in the same file, they will skip a number every time you run this script. You need a slightly more devious script in that case.

[ April 19, 2001: Message edited by: BobWeaver ]