Ye you really should look at putting another field in the db (normally the key field) and add auto increment to that. Then as a report number you can just add zeros to the front when you display it to the screen, this just makes all the numbers seem more "legit" so in the database it would be 1, 2, 3... and to the users the report number would be 00001, 00002, 00003...

__________________
iSearchNotes.com - Share College Student Notes | Blog