Ok my department wants me to find a way to simplify our current form that we enter info in.
We have a field called Mainframe_ID and this field keeps track of client's records.
When we get a new client, we give them the next logical number. THe problem is that this number includes a "BST" before the number.
I already have appx 6000 records, and it the last 5 data's that I have are:
BST6001
BST6002
BST6004
BST6005
I want to have the AUTO-NUMBER automatically populate this field with the next logical number... I can't figure out a safe way to do it - because as you can see, we have deleted some clients (notice that 6003 is missing). The entire set of records are like this - 1 missing out of every 10 - so I can't simply create a new field and auto-number it...
How can I append the auto-number code to the end of this set? (it is NOT currently set at auto-number).
We have a field called Mainframe_ID and this field keeps track of client's records.
When we get a new client, we give them the next logical number. THe problem is that this number includes a "BST" before the number.
I already have appx 6000 records, and it the last 5 data's that I have are:
BST6001
BST6002
BST6004
BST6005
I want to have the AUTO-NUMBER automatically populate this field with the next logical number... I can't figure out a safe way to do it - because as you can see, we have deleted some clients (notice that 6003 is missing). The entire set of records are like this - 1 missing out of every 10 - so I can't simply create a new field and auto-number it...
How can I append the auto-number code to the end of this set? (it is NOT currently set at auto-number).
