Hi,<BR><BR>I've got a table with usernames and passwords and a table with addresses. Both have an id column which relates the two. The id in the username/password table is an autonumber.<BR><BR>To create an account, first I insert the username and password. Then I select the newly generated id from that record before writing all the other data, including this new id number, into the other table.<BR><BR>What I'd like to know is, is there any chance that, after I have inserted the new record into the first table, the autonumber/id won't have been generated by the time the script goes to reads it?<BR><BR>Furthermore, do I have to use a new select statement to get this new id? Can I do it more efficiently?<BR><BR>Thanks,<BR><BR>It would be great to hear from somebody.<BR><BR>I.