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.
I have a couple of issues, the biggest being the title.
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.
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 # in infopath to match List 2
2) Minor issue, one field pulls user name (which I want) but also domain\username (which I don't want) Is there a way to prevent or not show the second part?
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)
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?