https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/85635.aspxWed, 26 Dec 2012 14:26:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:85635Mel Clemente0https://www.infopathdev.com:443/forums/thread/85635.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=85635<p>The technique used in my blog post might help: <a href="http://www.infopathdev.com/blogs/mel_balsamo/archive/2011/10/16/show-unique-rows-in-a-secondary-repeating-data-source-table-no-code.aspx">Show unique rows in a secondary repeating data source table - no code!</a></p>https://www.infopathdev.com:443/forums/thread/83956.aspxFri, 26 Oct 2012 20:00:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:83956mhamm0https://www.infopathdev.com:443/forums/thread/83956.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=83956<p>Hi!</p> <p>I&#39;m a noob.</p> <p>I am designing an InfoPath 2010 web form that submits to a SharePoint 2010 List. The template I am using was generated by SharePoint, if that matters. I want a special kind of validation: I wish to cross-reference the instances (Value .)&nbsp;of a group/repeating field (multi-choice/plain list&nbsp;control)&nbsp;to previously submitted&nbsp;instances (Value .)&nbsp;to determine &amp; exclude (weed out) identical instances from another selection control.</p> <p>Scenario:</p> <p>5 terms entered to a plain list control, repeating field. Say:</p> <ul> <li> <div>business</div></li> <li> <div>strategery</div></li> <li> <div>pickle</div></li> <li> <div>triangle</div></li> <li> <div>salmon</div></li></ul> <p>As each is entered (or another trigger, such as an action rule on Submit form, or another custom button) it is cross-referenced to the previously submitted forms by way of the column, same field, such that the instances of <u>pickle</u> and <u>triangle</u> have already been used once and an error is returned saying as much. &quot;The term pickle is already in use.&quot; &amp; &quot;The term triangle is already in use.&quot; The net result is a warehouse of unique instances, or terms.</p> <ul> <li> <div>business</div></li> <li> <div>strategery</div></li> <li> <div><strike>pickle</strike></div></li> <li> <div><strike>triangle</strike></div></li> <li> <div>salmon</div></li></ul> <p>The next form submitted might&nbsp;include the term <u>strategery</u>: which would result in an error because it was already recorded.&nbsp;</p> <p>Since they are words/terms/phrases, I would think converting the value instances to text (strings) might be part of it. </p> <p>In fact, I&#39;d like to do this with URLs as read-only text, too.</p> <p>I&#39;ve tried more than a few workarounds. It&#39;s time to consult the experts!</p>