I would like to create a custom autonumber to use as my primary key in one of my tables in my database.

I would like my records to be displayed as such C000001 , C000002 and so forth. Does anyone know how todo this?



Thanks in advance.

Use the search function provided here, there have been umpteen posts on the subject