|
-
Oct 6th, 2002, 02:45 AM
#1
Thread Starter
Fanatic Member
Last AutoNumber Value
My script inserts data to two tables. Table1 has an autonumber field, which is the primary key. The algo is the ff:
1. Insert record to table1. (thus creating a new value in the autonumber field).
2. Get the new value from the autonumber field of table1 and inserts it to table2.
My problem now is, how can i get the new value in the autonumber field from table1?
On Error GoTo Hell
Hell:
Kill Me
Food For Thought:
- Do not judge a book... if you're not a judge!
 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote