Dear All

I have a table with an autonumber field. This field generates auto numbering like 1,2,3,4,5.... etc.

I wish to customize this result like B-001, B-002, B-003....etc.

Is it possible ? If yes then how? Please help me.

Thanks.

The only way to do this is to use a manual primary key which I nearly always try and avoid.

For your example you would use a text field of length 5 and set it as the primary key.

You'd then need to write some validation to validate the input of the key and some code to generate the key.