Re: Challenging problem for you programing gurus...

<snip> >Chris Shiflett wrote: > I didn't catch which database you are using, but you can alter a field > in MySQL to add the auto_increment characteristic. Look into the "alter > table" SQL statement. </snip> And if you do that, there won't be any trouble with the existing IDs. mysql will grab the next higher number automatically. But test this on your own installation first, just to be sure ...