Autonumbering with Prefix

[finndy80]

I hope someone can please help me! I am now starting my second database but this time I am already starting with 676 records that are being imported from Excel, and then I will split the table.

Each records has a references such as QO8/053. I have created new column using the autonumber to create the unique identifier to help when I split the table, but I now need every new record created to look up to the last Q ref so it will infuture go QYY/053+1. if that makes sense

I don't know any code and have built my last one using very basic skills but from scratch so it was easy. A step by step guide would be helpful if anyone here has that much patience, how do you get prefixes and lookup to last number and then to work together????

 

[Rabbie]

There have been several threads recently on this topic so search the forum for them.

In summary you will need to split your reference into two fields - one for the prefix and one for the numeric part. Remember if you use Autonumber that you may get jumps in the sequence especially if you delete a record or there is a hiccup when inputting. Also you won't be able to reset the numeric part to 1 or Zero if that is required when you change the prefix.