Trying to capture and reuse primary key, getting type mismatch.

[bcapps]

I have code in an ASP page to insert some data, I want to insert into one table, retrieve the primary key from that entry and then insert that into another table. Here is what I have so far and I am getting type mismatch when trying to insert into the second table:

conn.Execute "insert into tblOne (AName) values ('" & Request.Form("BName&quot & "')"

set ANum = Conn.Execute("SELECT MAX(recordID) FROM tblOne&quot

conn.Execute "insert into tblTwo (tblOneNum) values (" & ANum & &quot"

I know I must be doing something wrong, but don't know what.

Thanks

 

[shaddow]

Try...

conn.Execute "insert into tblTwo (tblOneNum) values (" & ANum("recordID")& ")"

ANum is an Recordset witch contains a field named recordID and u dont use it correctly.
Hope this works. ________
George, M

 

[bcapps]

I tried that and now I am getting:

Item cannot be found in the collection corresponding to the requested name or ordinal.

Thanks

 

[shaddow]

There is one little change...

set ANum = Conn.Execute("SELECT MAX(recordID) as max FROM tblOne")
conn.Execute "insert into tblTwo (tblOneNum) values (" & ANum("max")& ")"

This should work... ________
George, M

 

[bcapps]

It's Working!!!

I Can't thank you enough!!!