I take it you're using an AUTO_INCREMENT field in your database, and leaving it blank, so the database fills it in automaticlaly when the record is added? I've done this with my database too, and it is quite annoying that the ID isn't actually stored or even created until the record has been added.

There is no way to query the next available ID in an AUTO_INCREMENT field, is there? Maybe this would be a work around? Not for this problem maybe, but it would be well useful for my program ;-)

- wil