form1.frm

来自「vb数据库编程资料」· FRM 代码 · 共 38 行

VERSION 5.00
Begin VB.Form Form1 
   Caption         =   "Form1"
   ClientHeight    =   1950
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   4710
   LinkTopic       =   "Form1"
   ScaleHeight     =   1950
   ScaleWidth      =   4710
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command1 
      Caption         =   "创建联系"
      Height          =   495
      Left            =   1200
      TabIndex        =   0
      Top             =   600
      Width           =   1935
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
  Dim MyDb As Database   '定义数据库变量
  Dim MyRel As Relation  '定义关系变量
  Dim MyField As Field   '定义字段变量
  Set MyDb = OpenDatabase(VB.App.Path & "\教务管理", True, False)  '打开教务管理数据库
  Set MyRel = MyDb.CreateRelation("课程成绩", "课程", "必修课成绩", dbRelationUpdateCascade)
     '建立课程表与必修课成绩表之间的关系
  Set MyField = MyRel.CreateField("课号") '创建关系字段课号
  MyRel.Fields.Append MyField  '把关系字段添加到关系的Fields集合中
  MyRel.Fields("课号").ForeignName = "课号"  '确定子表的相关字段
  MyDb.Relations.Append MyRel  '把建立的关系添加到数据库的关系集合中
End Sub