Select Case e.DataCol.Name
Case "安装单位"
If e.NewValue Is Nothing Then
e.DataRow("告知联系人") = Nothing
......清空其它列
Else
Dim dr As DataRow
dr = DataTables("设置表").Find("[安装公司] = '" & e.NewValue & "'")
If dr IsNot Nothing Then
e.DataRow("告知联系人") = dr("告知联系人")
......其它列赋值
End If
End If
End Select