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/93310.aspxThu, 26 Sep 2013 19:39:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:93310rednoc0https://www.infopathdev.com:443/forums/thread/93310.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=93310<p>Ok, so I am working on a project where my employeer has two SharePoint lists. One has most of the information needed to populate an InfoPath form the 2nd only has 2-3 columns that really give data.</p> <p>I have a couple of issues, the biggest being the title.</p> <p>1) Main issue, when pulling from List 2 I recieve the data into a List Box and the first items are exactly what I want (i.e. first 10), but then there is more and is not relevant.</p> <p>This is done by setting the List Box properties to pull from List 2 with the filter of (# in infopath to match # in List 1, ((this is because in List 2 that field is only a pointer to List 1 and using it results in no data) and 2nd #&nbsp;in infopath to match List 2</p> <p>2) Minor issue, one field pulls user name (which I want) but also domain\username (which I don&#39;t want) Is there a way to prevent or not show the second part?</p> <p>This is done by a rule that runs as action that populates the field with data from List 1 with filter (# in infopath to match # in sharepoint list)</p> <p>3) Minor isssue, the form seems to be a little slow, is there a way to get this form to be faster in loading/connecting?</p>