Re: reset auto increment to a lesser value

[Chris W]

Mark Goodge wrote:
> On a more general note, if the actual value of the primary key matters 
> for anything other than simply existing as a primary key, then you 
> shouldn't be using auto-increment at all. You should generate the 
> value through some other means and insert it with the value that you 
> want it to be.
>
> Mark
>

Can you elaborate on that point?  Do you not use auto-increment values 
to link records in a one to many relationship?

Chris W