Autoincrementing code record entry

[divined]

Hello everybody

I have a table with just two fields. The first is an autoincrementing integer and the second a string (text).My DBMS is MySQL.
Now, there is a form from which the user can enter a new record in the table. I would like the next autoincrement integer from the first field of the table to appear on the form. I thought of creating an ADO recordset object and fetching all records with a Select * Statement , thus counting all records. I believe that this approach will be time consuming.
Does there exists an easier method?

thx, in advance

George Papadopoulos

[mendhak]

SELECT COUNT(*) FROM Tablename

[mendhak]

Or better:

SELECT MAX(PrimaryKeyID) FROM TableName

[divined]

well, thx

I guess it comes easy when you`re into this stuff for some time!

[mendhak]

Indeed. Practice makes Mendhak.