Hello,I've been having very strange problems with AUTO_INCREMENT. It will be sequential for the first 4 or so inserts and display them fine. After 3 or 4 or 5 inserts the FileID, which has the AUTO_INCREMENT applied to it, will then jump to a seemingly random number like 72, 49207, and so on.My SQL for the table in question is:CREATE TABLE `IPR` ( `FileID` int(11) NOT NULL auto_increment, `Filename` varchar(40) NOT NULL, `ContentType` varchar(15) NOT NULL, `Description` varchar(150) NOT NULL, `Status` char(10) NOT NULL, `ApprovedBy` varchar(30) default NULL, `Created` varchar(15) NOT NULL, `Software` varchar(25) default NULL, `Registered` varchar(15) NOT NULL, `LocationDirectory` varchar(250) NOT NULL, `CopyrightGroup` varchar(25) NOT NULL, `FileCreator` varchar(30) NOT NULL, `Ownership` int(3) NOT NULL, `CopyrightStatus` varchar(20) default NULL, `Comments` varchar(200) default NULL, `SubmittedBy` varchar(30) NOT NULL, PRIMARY KEY (`FileID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;Even after these jumps, if I go in and delete or manually edit the record with the crazy FileID and then runALTER TABLE table_name AUTO_INCREMENT = 6;it will still carry on jumping numbers either immediately or a row or two later. It's driving me crazy. Any help would be very much appreciated.Thanks