lookup field in Form field


Posted by RMIC - May 11 ’15 at 06:48

When use a lookup field in "Form field" in Data Source Editor, no data is displayed. Is there already a solution?

Thanks smile

  • Dmitry Kozlov
    Dmitry Kozlov
    Member for: 8 years 3 months 29 days
    #1 by Dmitry Kozlov May 11 ’15 at 08:59

    Thank you for the good question. Actually, you can configure filtering by a lookup field of the form but you need to do extra work here. First, configure filtering in the Data source dialog of the Related items control. Next, drop HTML-control onto your form and turn its CDATA property into False. Then insert the following code into its Content property:

    <xsl:variable name="LookupValue" select="substring-before(substring-after(@LookupColumn,'&gt;'),'&lt;')"/>
        <xsl:value-of select="ddwrt:GenFireConnection(concat('*', '@LookupColumn=', ddwrt:ConnEncode(string($LookupValue))), '')" />

    Please, replace the highlighted text (LookupColumn) with the internal name of the lookup field from the form.

  • RMIC
    Member for: 6 years 8 months 10 days
    #2 by RMIC May 29 ’15 at 04:31

    This worked, thanks a lot!

Displaying 1 to 2 of 2 messages