Is there any way to get the ID number from my autoincrement Primary Key immediately after posting the data for the new record? <BR>Right now I have a Customer table that has name, company, etc. in it as well as a CustomerID field. This is the field that autoincrements so I don't have the number until after I post the new data. The current ASP code I have then goes back and queries for the name again. At this point I can get the ID.<BR><BR>I'm wondering if there's another way to do it without running a second query (what if I have two John Smiths?) and without having to deal with assigning incremented IDs on my own.<BR><BR>I've tried printing out the contents of ADOREC("CustomerID") immediately after calling ADOREC.Update but it still comes up blank. I can pull all of the other information back out of the posted record, just not the ID.<BR><BR>Any ideas?