ASP & ACCESS/SQL Server

This might be more of a database question than ASP. But when you create a database and then create relationships with the database, once you open an asp page say to create a new record; once the record is saved, shouldn't it also update the relationship with the table involved?

Unless I am doing something wrong, it is not updating the second table; for example:

rs.AddNew
rs("username") = Request.Form("txtUserName")
rs("password") = Request.Form("txtPassword")
rs("firstname") = Request.Form("txtFirstName")
rs("lastname") = Request.Form("txtLastName")
rs("email") = Request.Form("txtEmail")
rs.Update

Response.Write("Record has been added!")

Say the information is entered, because of the UserID field is "autonumber", that would be my primary key: so "1" would be related with the second table where I have:

upload.id (PK)
userID
Upload1
date1
Upload2
date2
Upload3
date3

If on the other table I have number of uploads to generate, whenever it adds a document, it would have the relationship of the username, and the upload:

But when I do that, even adding the code, it does not update the code. So what am I doing wrong? Do I have to do another Add.New at the same time for the second table?