Emulating a table with a Autonumber Field w/Mysql ?

Hi

With VB tables that have an autonumber field you also have that 
last row available in Access. However using mysql there is never
an "empty" row in your table. Is there any way to emulate this
behavior with mysql?? The reason I ask as I'm trying to migrate
an existing Access Application to use mysql in which the 
programmer set up a form that does just that the form just points 
to the last row of the table and you just type what you want in
the form and it saves it when a <CR> is typed. However using mysql
it won't work it only displays preexisting rows. I'm pretty sure it
does not work because of the fact the "new" row does not exist yet!! 
I was thinking that it might be possible to create a temporary table
in Access that would fetch all the prexisting rows into a new
table in Access and then add the new rows as needed and then export
them back to mysql but I have no idea how to implement that in VB as
I'm more savy with mysql, Access I know little about.

Thanks,

Dave

ps If need be I can send the form on request



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]