Passing AutoNumber to another form

[PK]

I am developing a survey using Front page 2003 and SQL server 2000. The first form i collect the client data and upload into a client table. In the second form i collect info. on a set of questions and upload into a response table. In the client table i generate a Autonumber. Now i am trying to get this clientID, and trying to update it to my response table along with responses - and i am stuck. Can you please suggest how to fix this problem.

 

[clintonG]

Get into SQL Server resources and learn about @@IDENTITY
and how it is used to obtain the value of the primary key for the last
inserted record.

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET csgallagher@ REMOVETHISTEXT metromilwaukee.com
URL http://www.metromilwaukee.com/clintongallagher/

I am developing a survey using Front page 2003 and SQL server 2000.

The first form i collect the client data and upload into a client table.
In the second form i collect info. on a set of questions and upload into
a response table. In the client table i generate a Autonumber. Now i am
trying to get this clientID, and trying to update it to my response
table along with responses - and i am stuck. Can you please suggest how
to fix this problem.