How to generate consecutive serial number after deleting last serial number
I have serial numbered "order number" field in my program. Consecutive serial numbers are automatically generated as I add new order. But if I add new order after deleting last order, the next generated order number is the next number of what I deleted.
For example, I have got 15 orders and last order number is 15. If I deleted last order which number is 15 and added new order, next order number is become 16 not 15.
After all, the order numbers are become nonconsecutive like this; 13, 14, 16, 17, 18.....
Please help me to generate consecutive order number which is starting from last actual order number
I use FMP12 Pro ADV