From: Martijn Tonies Date: November 25 2003 8:54am Subject: Re: help needed! List-Archive: http://lists.mysql.com/mysql/154475 Message-Id: <015701c3b331$ac3575e0$0e02a8c0@martijn> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Hi, (please reply to the list only) > Yes thanks but how do I then add a new auto number field and still keep the order? What order? What has an auto-number have to do with what order? Please explain your problem in detail - it might be completely clear to you, but we're outsiders :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com