L
LKSmith
I have two repeating tables. Each has one drop down listbox.
/dfs:myFields/dfs:dataFields/d:A_Contract/d:A_ContractHost/@ACH_HostID_Key
and the other:
/dfs:myFields/dfs:dataFields/d:A_Contract/d:H_HostContracts/@HHC_HostID_Key
When I change the value of the first table's field "@ACH_HostID_Key" I want
it to update the second table's field "@HHC_HostID_Key." When I insert a row
into the first table "A_ContractHost" I want a row inserted into the second
table "H_HostContracts". Then I when I change the value of the the first
tables field in row 2, I want to update the second table's field in row 2,
and so on.
What I have tried:
I set the default value of @HHC_HostID_Key to
"../preceding-sibling::d:A_ContractHost[1]/@ACH_HostID_Key" (with show xpath
selected)
When I update the first table's field, it does not update the second.
(although I think this should work...)
Also, to get the second row to insert automatically I entered this code
(VB.net 2005):
Public Sub A_ContractHost_Changed(ByVal sender As Object, ByVal e As
XmlEventArgs)
If e.Operation = XmlOperation.Insert Then
CurrentView.ExecuteAction _(ActionType.XCollectionInsert,
"H_HostContracts_2")
End If
End Sub
This inserts a row to the second table, when I insert a row in the first
table.
What am I doing wrong?
/dfs:myFields/dfs:dataFields/d:A_Contract/d:A_ContractHost/@ACH_HostID_Key
and the other:
/dfs:myFields/dfs:dataFields/d:A_Contract/d:H_HostContracts/@HHC_HostID_Key
When I change the value of the first table's field "@ACH_HostID_Key" I want
it to update the second table's field "@HHC_HostID_Key." When I insert a row
into the first table "A_ContractHost" I want a row inserted into the second
table "H_HostContracts". Then I when I change the value of the the first
tables field in row 2, I want to update the second table's field in row 2,
and so on.
What I have tried:
I set the default value of @HHC_HostID_Key to
"../preceding-sibling::d:A_ContractHost[1]/@ACH_HostID_Key" (with show xpath
selected)
When I update the first table's field, it does not update the second.
(although I think this should work...)
Also, to get the second row to insert automatically I entered this code
(VB.net 2005):
Public Sub A_ContractHost_Changed(ByVal sender As Object, ByVal e As
XmlEventArgs)
If e.Operation = XmlOperation.Insert Then
CurrentView.ExecuteAction _(ActionType.XCollectionInsert,
"H_HostContracts_2")
End If
End Sub
This inserts a row to the second table, when I insert a row in the first
table.
What am I doing wrong?