New Post

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?
 
H

Howard Brody

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

Hope this helps!

Howard Brody
 
Top