Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Using my auto-number primary key when adding a new record

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-11 : 09:47:53
Nathan writes "In my database the primary key for my records is an auto-number field. I would like to use this auto-number in another field of the record. It seems that the only way to do this is to create the record, and then requery to get the auto-number and use it. Is it possible to get the value of the auto-number without requerying?"
   

- Advertisement -