Hi,<BR>I'm inserting some data into a database. The autonumber is not automatically created by the database therefore I have to create it in my code. Can someone please tell me how to read the last record of autonumber field? I need to read this field so that I can increment it by 1 for the next insert. For ex. the last auto# is 1000 when the next customer submits the order the auto# will be 1001. Thanks for your help!