Possible to "Auto Enter Previous + 1"?

[GMOcreator]

When a new record is created: Is it possible to make the field auto enter the previous value of that field plus one? IE: If the last value in the field was 12, then the auto-entered value on the new record in that field is 13. Serial won't work, because I frequently must reset the value of the field to 1. Thanks

[Ocean West]

Field:

iOne: "1" (Calculation, Result Number, Stored)

Relationship:

Related (Self Relation iOne = iOne)

Field:

Record_No (Number, Stored)

Field:

Next_No: "MAX(RELATED::FIELD)+1" (Calculation, Result Number)

I would recommend using a script to set the number in the Record_No field instead of auto enter, this way you can control when to increment the number, before or after a bunch of other script steps.