https://www.infopathdev.com:443/forums/131.aspxqRules adds support to your InfoPath forms. With qRules, you can add features to your form that require code, but without having to write it. enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/82828.aspxWed, 19 Sep 2012 13:17:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:82828ErnestoM0https://www.infopathdev.com:443/forums/thread/82828.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=82828<p>I have done what you propose; that is, storing both the ID and the display name in the form, and promote the display name as the column in the form library.<br /></p><p>You might also try having the column defined as Managed Metadata. (Screenshot attached.) Perhaps this enables SharePoint to treat this like a lookup column? I haven&#39;t tried myself, but it might be worth trying it out. Let us know whether it works! <br /></p>https://www.infopathdev.com:443/forums/thread/82818.aspxTue, 18 Sep 2012 23:23:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:82818GrandmasterPhil0https://www.infopathdev.com:443/forums/thread/82818.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=82818<p>Hi all,</p><p>I am able&nbsp;to successfully retrieve managed metadata terms and save them to my form.&nbsp; However,&nbsp;when adding&nbsp;the column to the SharePoint list (so it displays on the site), the&nbsp;Term ID is displayed, rather than the friendly display name.&nbsp;</p><p>Is there any easy way of displaying the friendly name of the term, rather than the ID, when adding the column to your forms library?&nbsp; The only workaround I&#39;ve thought of is to create a hidden variable in the form that stores the friendly name, and choose to add that one to the list instead.</p><p>Thanks!<br /><br />Phil</p>