Combine Text and Auto Number to create a unique ID
Posted on 2012-08-19
I need to create a unique ID in a table when an access record is created on a form.
I want to combine a text string with the auto number so that the default auto numbers from different data sources would not result in a duplicate.
The text string would be the first two characters from one field and some zeros combined with the auto number. I would like to control the field length so that it would sort alpha numerically in the order that the records were created.
IE: Combine the fields [Location] and [ID] so the result is Lo000001:Lo000999,Lo001000... etc.