Sorry for the off topic post. I have just copied a DB from one site to a new one I am developing. I have deleted all of the data but when I insert new records the auto numbers do not start at 1 - they start at whatever index they were at in the last site.
How do I reset this to start at 1? I have tried turning it into a number field and back, have also tried deleting the field then putting it back. Neither of these seemed to work. Thanks Giles Roadnight http://giles.roadnight.name -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
