retrieving the last record number inserted in Access database?

[greenber2]

is there a server behavior for  Dreamweaver CS 5 to retrieve the last record number inserted into a  database? I have two tables in an Access database, what is called  "login", the other is called "customer". The login entry is created  first, then upon successful creation the customer record is created and  inserted. I wish to tie the two tables together with the auto number  from the customer table inserted into a field in the login entry so that  once logged in the customer entry can then be accessed. So I am looking  for either a server behavior or some canned code that would do just  that. Is such a thing available?

Ross

[bregent]

There is no server behavior for this. If you are using Jet 4.x, you can use the @@identity query:

http://support.microsoft.com/kb/232144/en-us