Dear Community: I need your help. I need to create a numeric field (not a key) that sequentially increments a unit each time a record is generated. Could someone help me with an idea? Thanks in advance
Hello Aleksi, I read the article. In my case I want to assign a range of numbers to each of the 6 users I have, so there are no problems with the sequential increase. For example, - User one will have the range of 10000001 up to 1999.9999 - User two will have the range of 20000001 to 29999999 Is it possible to work in this way. Thanks in advance.
Yes it’s possible.You just need to read the max number for that user from your existing table and then + 1.