Revert record does not revert serial number

[Osman]

Hi,

I generally un-check "save record changes automatically" option in data entry list views.

But the problem is about serial numbers. Order No field is auto enter serial number field. If the user creates new record and don't save it, record automatically deleted but it does not roll back serial number.

I know this is not a bug of FileMaker but it is not the case I want.

So, I am searching for a best way to do it. The alternatives that I am considering are:

- New record script always set next serial value (this may be slow down in huge data)

- Trigger may help about this issue (but there is no onRevert trigger option)

- Control new record process within a script and new layout (doing this job on 6 tables may be time wasting)

I wonder is there any other alternatives? Or which is the best way, any opinion?

Thanks,

Osman Cabi

[comment]

You can set the auto-entered serial number to be generated on commit only.

[Osman]

Thanks

How could not I see that :