HI have a Database [access 2003 as front end and SQL Server 2000 as Engine] that I have inherited and it's primary key is an autonumber [IDENTITY] and I cant stand that because it allows duplicates, is there a way that I can create my own autonumber in SQL it would be something like first part would be the year 06-0000 - 06-9999 is this possible??
Now I was told
"If the field is an IDENTITY and a Primary key there should not be any duplicates which is the way it is supposed to work.
Create a function to create ot 06-0000 number and not rely on the IDENTITY field for that because it wasn't designed to be used that way."