[wafers08]

i have 2 tables with relationship

accounts table
accNo - Primary Key
username
password

students table
studentNo - Primary Key
accNo - Foreign Key
FName
LName

the problem is when i add new data
the students.accNo in not updated

Private Sub Command1_Click()
With Adodc1.Recordset
    .AddNew
    !UserName = Text1.Text
    !Password = Text2.Text
    !FName = Text3.Text
    !LName = Text4.Text
    .Update
End With

Adodc2.Refresh
Adodc3.Refresh

End Sub

i attach my database so you can see my codes clearly

thanks for your help

[BobRodes]

That's because the default recordset type of a data control isn't updatable. Read up on CursorType, LockType, and CursorLocation properties of the ADO recordset.