http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=50080
If e.DataCol.Name = "项目名称" Then
If e.NewValue Is Nothing Then
e.DataRow("项目编号") = Nothing
e.DataRow("建设单位") = Nothing
e.DataRow("项目负责人") = Nothing
Else
Dim dr As DataRow
dr = DataTables("项目合同信息表").Find("[项目名称] = '" & e.NewValue & "'")
If dr IsNot Nothing
e.DataRow("项目编号") = dr("项目编号")
e.DataRow("建设单位") = dr("建设单位")
e.DataRow("项目负责人") = dr("项目负责人")
else
e.DataRow("项目编号") = Nothing
e.DataRow("建设单位") = Nothing
e.DataRow("项目负责人") = Nothing
End If
End If
End If