I am trying to setup a list of books in table using SQL I have the list setup with all the data. But I want to have an autonumber field. So each book would have a number any body know a fix. I believe the "Identity" will work but I need more info about it. Like if I want a field called number (which will be the autonumber) do I set it to identity. please help anyone?