https://www.infopathdev.com:443/forums/142.aspxAre you exploring new features coming up in 2010? Share information and ask questions here!enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/88207.aspxWed, 20 Mar 2013 07:44:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:88207Evy0070https://www.infopathdev.com:443/forums/thread/88207.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=88207<p>Thanks for your reply JenniferLindsay!</p><p>The list employees contains the columns: Employeename, employeenumber. The list messages has the following columns: employeename, employeenumber, message. </p><p>I&#39;ve 2 data connections. One for the list employees and one for the list messages. When i want to calculate the messages per employee, it says always one. </p><p>Is a repeating table the correct way to show al the employees? In the repeating table i have a dataconnection with the list employee. One column i coupled&nbsp;to the dataconnection of the list messages. In this column i want to show the number of messages. I changed the type to calculated field.The formule: count(employees) where the employee is the same as the record from the list employees. </p>https://www.infopathdev.com:443/forums/thread/88180.aspxTue, 19 Mar 2013 16:47:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:88180JenniferLindsay0https://www.infopathdev.com:443/forums/thread/88180.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=88180<p>&nbsp;</p><p>&nbsp;Hi Evy,</p><p>You can access list data inside InfoPath by setting up a secondary data connection and then querying the data connection to import specific data from the list.&nbsp; Here is a link to instructions on how to query a SharePoint list and import data into InfoPath:</p><p><a href="http://office.microsoft.com/en-us/infopath-help/add-a-data-connection-to-a-sharepoint-document-library-or-list-HP010093160.aspx#BM3">http://office.microsoft.com/en-us/infopath-help/add-a-data-connection-to-a-sharepoint-document-library-or-list-HP010093160.aspx#BM3</a></p><p>How is your &quot;messages&quot; list set up?&nbsp; What columns does it contain?&nbsp; The list structure will determine what list columns are needed and what calculations need to be performed.</p><p>&nbsp;</p><p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/88167.aspxTue, 19 Mar 2013 14:33:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:88167Evy0070https://www.infopathdev.com:443/forums/thread/88167.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=88167<p>Hi, I&#39;ve a list &quot;employees&quot; which contains all the employees of the company. I&#39;ve also a second list &quot;messages&quot;, this list has messages about some employees. (Not everyone has a message, some employees can have more than one message) I would like to show all the employees and the number of their messages. For example: Evy has 1 messages Jef has 2 messages Kate has 2 messages Kelly has 0 messages. Is it possible to create this in InfoPath? I&#39;ve tried, but didn&#39;t succeeded :( </p>