Auto Enter Model Number - A001...A999, B001...B999, etc.

[Dana G]

I need to know how to set up a field to calculate the next model number.

 

Currently the method is to find the max and add 1[Max(veh_SELF_type::Model ID) + 1].  This has worked in the past.  Letters have recently been introduced for a certain type of item so the current method will need to be tweaked.

 

I currently have 4 records for this new type of item (Model Nums - A001, A002, A003, A004).  When I add a new item, the current method gives me model num "5" instead of "A005".

 

Also, once the numbers get to A999, the next one will need to be B001.

 

I also have to skip I, O and Q letters.

 

I appreciate any help.