>Hi All,
> I have a primary key in one of my table. When the record is added the primary key is increased to next number. I have been testing and the primary key is 100, however my client want the primary to start to one. Thus, is there a way that would allow me to reset the primary key back to 1.
>
>Thanks, this will save me .

Then every day that the client will cancel the "1" you will have to
move back the pk ?

If the client wants a code, you add a field code.