Return autonumber value of newly inserted value?? 1

[jonscott8]

I'm INSERTing a record into an Access database that uses the AutoNumber datatype for its primary key field. Table definition is as follows:

Table: RefHdr
Fields: RefHdrKey AutoNumber
AuthNo Char(13)
Comment Char(30)

I do a: INSERT INTO RefHdr (AuthNo,Comment) VALUES ('3001','Referred to Dr. X')

After doing the INSERT, how can I determine what Access assigned to the RefHdrKey field value, baring in mind that this is a multi-user system with new records being added every few seconds?

FWIW, I'm using SPT from a VFP front-end.

Thanks In Advance.

Jon Jon Hawkins
jonscott8@yahoo.com

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed

 

[jonscott8]

Since I've received emails inquiring if I ever resolved this, I thought I'd post a follow-up to this thread.

Please see thread181-37895. Jon Hawkins