I can change the auto number field to hold sequence value like "A-1", "A-2" or "B-1", "B-2" by setting the format property of field but I want to change the sequence each time when records count reach to 99999 records.
for example
- for first 99999 records, sequence will be "A-1" to "A-99999".
- After that for next 99999 records (100000-199999) sequence will be "B-1" to "B-99999".
- and so on...
is it possible or not? any guidance or link will be appreciated
