How to retrive primary key for e-mail message after writing to SQL

[xfile]

Hi,

Can anyone help me this for retrieving primary key from SQL for sending
e-mail message after inserting data from form to table?

I know how to insert form data from form to the table, and then using data
from the form field for sending confirmation e-mail message to the user.

However, I wish to make it one step further by retrieving the primary key
from the row of the data just been inserted and placed it into the e-mail
message so it could be used as a reference number, for example.

Appreciate if anyone can give me some directions.

Thanks,

 

[Kathleen Anderson [MVP - FrontPage]]

http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Autonumber

 

[xfile]

Hi,

Many thanks, that's a good start

http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Autonumber

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/