How can i let the program create key automatically in succession ?
I tried using the function UNIQUEID() but it is giving random key numbers ( Not in succession )
Solved! Go to Solution.
You can use MAX(TableName[ID])+1 in initial value field but please remember that if you have more than one user or one user with two devices, you probably will have duplicates.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |