Hi, I am using InfoPath 2007.
I have a secondary data source.
myFields
dataFields (group)
Who_To_Copy (repeating group)
Business
Region
Email
Admin.
In my main data source I have
myFields
SKUIntroductionGroup - group
Business
Region (repeating field)
I want to concatenate the email field from Who_To_Copy where the Business matches the Business in the main data source, and the Admin is set to true, AND the region matches any of the non blank regions set in the main data source. It is the last criteria that I am having problems with... so far I have the following. which works
xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Who To Copy")/dfs:myFields/dfs:dataFields/dfs:Who_To_Copy[@Business = xdXDocument:get-DOM()/my:myFields/my:SKUIntroductionGroup/my:Business and @Admin = "1"], 'concat(@Email, "; ")'), "..")
I have tried adding the following to the filter - but that does not work.
and count(xdXDocument:get-DOM()/my:myFields/my:SKUIntroductionGroup/my:Region[. = xdXDocument:GetDOM("Who To Copy")/dfs:myFields/dfs:dataFields/dfs:Who_To_Copy/@Region]) > 0
I have tried adding and that doesn't work.
and count(xdXDocument:get-DOM()/my:myFields/my:SKUIntroductionGroup/my:Region[. = current()/@Region]) > 0
Is this a step to far ? Is there a way to achieve this ?
Thank you
Catharine