[thelist] ASP - Access

[Harold Maduro]

Another boring question:

I got an ASP page where i input some data into a table in Access Database
(let's call this, TABLE A).  After this is done, i want to redirect the
user to a page to input more data on another  table (TABLE B) that has a
relationship with TABLE A..

In TABLE A, i have an id field that it's an autonumber.  On my second page
(right after submitthing and introducing the data on TABLE A) i have to
know the ID number of the record i just introduced, how do i do this?

I used to make a query and get the id number of the last record, but that
gave me problems, because several users will be introducing data at the
same time.


Any ideas?