https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/102843.aspxTue, 16 Jun 2015 20:58:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:102843leecarver0https://www.infopathdev.com:443/forums/thread/102843.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=102843I&#39;m using Infopath 2010 and Sharepoint 2013 to develop a form that will be used to maintain a list on Sharepoint. This list contains several columns, some of which contain non-unique values and others which are wholly unique. For example:<br /><br /> Column 1 Column 2 Column 3<br /> A C G<br /> A C J<br /> A D I<br /> B E K<br /> B F L<br /><br /> My goal is I want to display a repeating table that is filtered based on a selection in a drop down list (which I have already accomplished), but only displays unique values.<br /><br /> After creating a data connection with this table, I created a drop down list that has been filtered to select only unique values within Column A. Based on the selection for Column 1 from the drop down list, I want to create a repeating table that populates with all the unique values for Column 2. In other words, if someone were to select value &quot;A&quot; in the drop down list, they would see a repeating table showing only one instance of values C and D. I have been able to create a repeating table that will display all instances of values in Column 2 based on the selection for Column 1, but cannot figure out how to filter for unique values.<br /><br /> I&#39;ve been able to achieve the &quot;desired&quot; results using List Boxes, but these have some formatting issues I dislike or are not amendable to the volume of data. Has any one ever dealt with this problem? I&#39;ve searched the forums for about two hours, but most of the issues seem to be with validating data going out rather than coming in. Any guidance would be greatly appreciated.