Elton1984
Programmer
- Mar 8, 2004
- 16
Hi all,
I have a problem here where i am supposed to insert records into 2 tables.
Table A has a primary key (loanindex) which is an autonumber. And i need to get the loanindex of the just inserted record and insert it into Table B.
I have seen some forums, and notice that's a method regarding "@@identity".. I would like to know how do u go around using that method without the used of a stored procedure...
Codes snipplets would be greatly appericated...
Thanx in advance
Elton
I have a problem here where i am supposed to insert records into 2 tables.
Table A has a primary key (loanindex) which is an autonumber. And i need to get the loanindex of the just inserted record and insert it into Table B.
I have seen some forums, and notice that's a method regarding "@@identity".. I would like to know how do u go around using that method without the used of a stored procedure...
Codes snipplets would be greatly appericated...
Thanx in advance
Elton