如何解决在多表关系中添加记录的问题(修正图片不显示问题)

现在又几个表，关系如下当我执行如下代码时就会出现Adodc2.Recordset.AddNew    Adodc2.Recordset.Fields("studentNumber") = text(0).text
    Adodc2.Recordset.Fields("studentClass") = text(18).text
    Adodc2.Recordset.Fields("studentName") = text(1).text
    Adodc2.Recordset.Fields("studentSex") = txt2.text
    Adodc2.Recordset.Fields("studentBirthday") = CDate(text(2).text)
    Adodc2.Recordset.Fields("studentPoliticsface") = text(3).text
    Adodc2.Recordset.Fields("studentEntranceTime") = CDate(text(4).text)
    Adodc2.Recordset.Fields("studentYardDepartment") = text(5).text
    Adodc2.Recordset.Fields("studentNativePlace") = text(6).text
    Adodc2.Recordset.Fields("studentIDCard") = text(7).text
    Adodc2.Recordset.Fields("studentFamilyAddress") = text(8).text
    Adodc2.Recordset.Fields("studentRes") = text(9).text    Adodc2.Recordset.Fields("CommonClass") = Val(text(10).text)
    Adodc2.Recordset.Fields("SpecializedCourse") = Val(text(11).text)
    Adodc2.Recordset.Fields("ExamineClass") = Val(text(12).text)
    Adodc2.Recordset.Fields("DoubleDegree") = Val(text(13).text)
    Adodc2.Recordset.Fields("ElectiveCourse") = Val(text(14).text)
    Adodc2.Recordset.Fields("ExtracurricularCredit") = Val(text(15).text)
    Adodc2.Recordset.Fields("CET-4") = Val(text(16).text)
    Adodc2.Recordset.Fields("CET-6") = Val(text(17).text)
    'Adodc2.Recordset.Fields("Info.studentNumber") = text(0).text
    'Adodc2.Recordset.Fields("classInfo.studentClass") = text(18).text    
    Adodc2.Recordset.Fields("classInfo") = text(19).text
  
    Adodc2.Recordset.Update当我把
Adodc2.Recordset.Fields("studentNumber") = text(0).text
    Adodc2.Recordset.Fields("studentClass") = text(18).text改成
Adodc2.Recordset.Fields("studentInfo.studentNumber") = text(0).text
    Adodc2.Recordset.Fields("studentInfo.studentClass") = text(18).text就会出现如下错误