New Post

  • Thread starter Thread starter Bjarne Lindquist
  • Start date Start date
B

Bjarne Lindquist

How to determine the new autonumber

Table tNew
-------------
[ID] Autonumber PRIMARYKEY
[Material] Text(50)


I want to insert a new record like

INSERT INTO tNew ([Material])
SELECT [WhatEverText]


This work ok, then my problem is what is the new [ID]?

Can anybody help?
 
The AutoNumber should autopopulate with each new record so
you don't have to build it into your query.

Hope this helps!

Howard Brody
 
Back
Top