用VBA代碼建立表間字段的關(guān)系

Sub CreateRelationX()
    Dim relNew As Relation
    With CurrentDb
    　Set relNew = .CreateRelation("表2表1ID編號", "表2", "表1", dbRelationDontEnforce +　dbRelationUnique) 'dbRelationUnique)表示一對一
    　relNew.Fields.Append relNew.CreateField("ID")
    　relNew.Fields!ID.ForeignName = "編號"
    　.Relations.Append relNew
    　.Close
    End With
    End Sub