When I write a new record to a table that has a field named ORDERID as an Identity, I want to be able to pull back the ID that the database just assigned to that record. (I am using ASP and SQL.) I checked the FAQ's and could not find anything on this. Can someone help? If you need more detail let me know.