0
Auto incrementing account numbers
We have inported data from our previous database and need to have auto incrementing account numbers for clients carrying on from our existing data.
Can you please advise how we do this, thank you
2 replies
-
Use the max(TableName.Field)+1 function.. Watch out for race conditions if using the Cloud version and you have multiple people entering it... You may also want to add an alert to after create to ensure two users did not hit the create at the exact same time and create a duplicate.
-
Having the exact same requirement; how exactly would an alert prevent duplicates?
Content aside
- 5 yrs agoLast active
- 2Replies
- 2608Views