AnsweredAssumed Answered

How to generate consecutive serial number after deleting last serial number

Question asked by JeongwungJeong on Aug 14, 2013
Latest reply on Aug 15, 2013 by philmodjunk

Title

How to generate consecutive serial number after deleting last serial number

Post

     Hello 

     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

     Thank you

     Wung

Outcomes