Is there a method to get sql to have an autonumber field. I am inserting rows of a table in a webpage. I need to either get the Record identification field to advance each time I put in a message or I will have to retrieve the last message and then add 1 to it. I would prefer not to have to do it the second way because it may cause complications. Can someone advise! Charles Black 4127 Pinehaven Ct. Columbia, SC 29205 Phone: (803) 790-5586 Cell: (803) 873-1698