Revert records don't advance serial number
At the moment I have problem with my database.
I have a layout that registers my projects. In this Layout I have a field that is auto generated by serial.
I have some other fields that have to be "not empty". When I don't fill these fields the application returns the revert record error. If I decide to revert record, because I want to cancel the creation of a new project, it passes on to a new project, but the serial number advances.
What I want to do is that when I revert a record or cancel it in any other way, the serial number goes back to the last number before doing this action.
I don't really know how to explain this in another way.
Will be very thankful if someone can help me with this.
Thank you very much.
I'm using File Maker Pro 10 Advanced on Mac OS X.