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/57962.aspxFri, 13 Aug 2010 10:34:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:57962Stevio0https://www.infopathdev.com:443/forums/thread/57962.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=57962<p>Found the solution in this threat: <a href="http://www.infopathdev.com/forums/p/858/39921.aspx">http://www.infopathdev.com/forums/p/858/39921.aspx</a></p>https://www.infopathdev.com:443/forums/thread/57933.aspxThu, 12 Aug 2010 14:52:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:57933Stevio0https://www.infopathdev.com:443/forums/thread/57933.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=57933<p>In Infopath 2007 I have created a repeatable table with a data connection to Sharepoint. In&nbsp;Sharepoint there is a list of all pupils (600 approx)&nbsp;(first and last name, classroom)</p> <p>The repeatable&nbsp;should look like this:&nbsp;<br /><br />Classroom&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; number of pupils.</p> <p>A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp; </p> <p>A3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</p> <p>B7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</p> <p>&nbsp;</p> <p>First I had the problem with duplicated Classrooms, since there are +- 20 pupils in a class. With&nbsp;preciding-sibling&nbsp;as the&nbsp;conditional-format on the table this was solved.<br />The only thing that still remains that I cannot get the number of pupils right. Is the following possible? To get the value from the row next to the number of pupils&nbsp;and use this as a default value on a field.</p> <p>Like: count(@Classroom[contains(.; &quot;<strong>{getvalue of each left row}</strong>&quot;)])&nbsp;&nbsp; ?</p> <p><br />So it will show &quot;A1&quot; = 3<br />and in the next one &quot;A3&quot; = 7</p> <p>Instead of now I got everytime as a result 1 on all fields.</p> <p>How can I do this or get this working?</p> <p>&nbsp;Thanks for any help.</p>