窗口表的currentChanged事件,改成
Dim dr As DataRow = e.Table.Current.DataRow
Dim wz As Integer = Tables("入库订单表").FindRow(dr)
If wz >=0 Then
Tables("入库订单表").Position = wz
End If
'换行时,同客户列同步:
Tables("客户表").filter = ""
Dim i = Tables("客户表").FindRow("客户 = '" & e.Table.current("客户") & "'")
If i>=0 Then
Tables("客户表").position = i
Else
Tables("客户表").filter = "1=2"
End If
'入库订单表_入库明细表--模拟关联表:
If Forms("意和表窗口").Opened() '一定要判断用于模拟关联表的窗口是否已经打开
Dim t2 As Table = Tables("意和表窗口_入库明细表")
With e.Table
If .Current Is Nothing Then
t2.Filter = "False"
Else
t2.Filter = "入库编号 = '" & .Current("入库编号") & "'"
End If
End With
End If
' "入库订单表"选择换行时,判断窗口是否已打开,若已打开,则更新Tables("意和表窗口_入库明细表")的Filter属性,显示新选定的行.
'入库订单表_出库明细表--模拟关联表:
If Forms("意和表窗口").Opened() '一定要判断用于模拟关联表的窗口是否已经打开
Dim t3 As Table = Tables("意和表窗口_出库明细表")
With e.Table
If .Current Is Nothing Then
t3.Filter = "False"
Else
t3.Filter = "入库编号 = '" & .Current("入库编号") & "'"
End If
End With
End If
' "入库订单表"选择换行时,判断窗口是否已打开,若已打开,则更新Tables("意和表窗口_出库明细表")的Filter属性,显示新选定的行.