Help with Current() .. have never been able to get it to work.

[esebastian]

Hello There,

I think my scenario is in need of the Current() function but i try to
avoid it because i can never get it to work. I have a combo box and
it's display and value nodes are set to the name column in a secondary
data source .. the xpath to that field is: /dfs:myFields/
dfs:dataFields/d:NavigationGroups/@Name

When the value of the combo box has been changed i need a field in my
main datasource to fill with the ID field of the secondary data source
(and no i can't change the value node of the combo box to be the id of
the secondary data source, with what we are doing i need the value to
be the name but i also need the id for later use)

The xpath to the field i want to store my id in = /my:myFields/
my:Survey/my:Inspection/my:InspectedAssets/my:InspectedAsset/my:ass_ID

The xpath that the id field is in the secondary datasoure = /
dfs:myFields/dfs:dataFields/d:NavigationGroups/@Id

I think there must be a way to set a rule with a filter on it to
populate the field in the main data source but i can't seem to get it
to work, i have had many hard times with the current() function and so
i avoid it. If someone can help me out with any kind of advice that
will work that would be great.

Thanks,

Erin

 

[esebastian]

Thanks AGAIN to S.Y.M, who has saved me once again... this article
helped me out.

http://enterprise-solutions.swits.net/infopath/shrinking-dropdown-list-repeating-table.htm