I am trying have an auto number field that is displayed when adding/editing a record.

Our reference numbers are in the format: B-879 and increase by 1 each time. When it gets to B-999 the next record is C-000.

Is it possible to do this?

Any help much appreciated.

Thanks,