Hey all, I have tried different things such as reindex and vacuum on my primary key auto inc field but I cannot reset it so that things start from one. I deleted everything from my table but it still keeps the amount that was there beforehand on the auto inc so anything new is appened to that number so I used to have 7 records when I insert new it starts at 8, how can I start it back from 1, its beginning to drive me a little crazy.
Thanks a lot - Jon
