determine value of auto-increment field after adding record - @ runtime

I have a table that will auto increment it's PK field upon adding a new record. I would like obtain that auto-increment value immedicately after the add of that record so that I may reference it within another table ... sort of an informal PK/FK relationship. In SQLServer I believe I recall

Re: determine value of auto-increment field after adding record - @ runtime

last_insert_id() - neal wrote: I have a table that will auto increment it's PK field upon adding a new record. I would like obtain that auto-increment value immedicately after the add of that record so that I may reference it within another table ... sort of an informal PK/FK

re: determine value of auto-increment field after adding record - @ runtime

neal, Wednesday, September 18, 2002, 11:17:49 AM, you wrote: n I have a table that will auto increment it's PK field upon adding a new n record. I would like obtain that auto-increment value immedicately after n the add of that record so that I may reference it within another table ... n sort