It really shouldn't matter as the PK is used for internal use..referential integrity, etc.
>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 .
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer