Combine two SharePoint columns into one InfoPath ComboBox

altja — Wed, 02 Jul 2008 21:05:44 GMT

Question 1) I can get it to concat with my dash, but I cannot get the right values to display in the second part. The second part always displays the first entry from the sharepoint list.

I tried to create my second part val2 <xsl:variable name="val2" select="my:itemAccount"/><xsl:if test="not(xdXDocument:GetDOM("Chart of Accounts")/dfs:myFields/dfs:dataFields/dfs:Chart_of_Accounts/@Shortt_text[../@VisiblePaymentRequest = "1"][.=$val2] or $val2='')"> and then using that in the concat, but that did not work.

Qustion 2) Where is dot being set at? I assume it reprsents the slected val.

Many thanks to any answers to my questions.

Sincerly,

Joe

My actual xlt code.

</div>Account:<select class="xdComboBox xdBehavior_Select" title="" style="WIDTH: 100%" size="1" xd:CtrlId="CTRL443" xd:xctname="dropdown" xd:binding="my:itemAccount" value="" xd:boundProp="value" tabIndex="0">

<xsl:attribute name="value">

<xsl:value-of select="my:itemAccount"/>

</xsl:attribute>

<xsl:choose>

<xsl:when test="function-available('xdXDocument:GetDOM')">

<xsl:variable name="val" select="my:itemAccount"/>

<xsl:if test="not(xdXDocument:GetDOM("Chart of Accounts")/dfs:myFields/dfs:dataFields/dfs:Chart_of_Accounts/@Account_number[../@VisiblePaymentRequest = "1"][.=$val] or $val='')">

<xsl:attribute name="value">

<xsl:value-of select="$val"/>

</xsl:attribute>

<xsl:value-of select="$val"/>

</option>

</xsl:if>

<xsl:for-each select="xdXDocument:GetDOM("Chart of Accounts")/dfs:myFields/dfs:dataFields/dfs:Chart_of_Accounts/@Account_number[../@VisiblePaymentRequest = "1"]">

<xsl:attribute name="value">

<xsl:value-of select="concat(.,' - ', /dfs:myFields/dfs:dataFields/dfs:Chart_of_Accounts/@Short_text)"/>

</xsl:attribute>

<xsl:if test="$val=.">

<xsl:attribute name="selected">selected</xsl:attribute>

</xsl:if>

<xsl:value-of select="concat(.,' - ', /dfs:myFields/dfs:dataFields/dfs:Chart_of_Accounts/@Short_text)"/>

</option>

</xsl:for-each>

</xsl:when>

<xsl:otherwise>

<xsl:value-of select="my:itemAccount"/>

</option>

</xsl:otherwise>

Newbie Questions

Combine two SharePoint columns into one InfoPath ComboBox