I have a database which I am trying to setup which has an autonumber field (which the user will not see) giving just a standard number.
From this number, I want to be able to give the user a 'file reference', which will be in the format BB/09/C/1234, and have this stored in another field.
BB...