«

ASP 3 and Access 2000. I have a page which enters a row into a table, and
then enters some other info into another table. Problem is, I need to do the
first one, then obtain the PK, which is an Autonumber, so I can enter it
into the other table.

I know how to do this in SQL Server with identity columns, but this is
Access. (I know Access is not very good, but I have to use it for this
church project.)

Here's my code:

strFName = Replace(Trim(Request.Form("FName")),"'","''")
etc.

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[etc]"
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.ConnectionString = strConnection
objConnection.Open
strSQL = "INSERT INTO Personal(etc) "
strSQL = strSQL & "VALUES(etc) "
objConnection.Execute strSQL

So now I need to do a SELECT from the Personal table, then enter that into
the table which consists of 2 fields, both of which are FK's for other
tables (this table was put in to resolve a many-to-many relationship)

FWIW, I'm doing this in a loop; that is, I have a variable number of
checkboxes, and for each one checked by the user, I'll have to insert a row
into this 2nd table. One one entry into the first table, though.

Any help would be appreciated.

"middletree" <> wrote in message
news:...
> ASP 3 and Access 2000. I have a page which enters a row into a table, and
> then enters some other info into another table. Problem is, I need to do
the
> first one, then obtain the PK, which is an Autonumber, so I can enter it
> into the other table.

http://www.aspfaq.com/show.asp?id=2174

Ray at home

Dang! I usually go to aspfaq first, but didn't do it this time. Thanks!


"Ray at <%=sLocation%>" <myFirstNameATlane34dotKOMM> wrote in message
news:...
>
> "middletree" <> wrote in message
> news:...
> > ASP 3 and Access 2000. I have a page which enters a row into a table,
and
> > then enters some other info into another table. Problem is, I need to do
> the
> > first one, then obtain the PK, which is an Autonumber, so I can enter it
> > into the other table.
>
> http://www.aspfaq.com/show.asp?id=2174
>
> Ray at home
>
>