https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/12181.aspxWed, 19 Apr 2006 14:31:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12181Matt Faus0https://www.infopathdev.com:443/forums/thread/12181.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12181Try adding one more data filter:<br /><br />"column1" "is not blank" AND<br />"column2" "is not blank" AND<br />"column3" "is not blank"<br /><br />I haven't tried this but it seems like it would work.https://www.infopathdev.com:443/forums/thread/12180.aspxTue, 18 Apr 2006 16:11:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12180WickedShark0https://www.infopathdev.com:443/forums/thread/12180.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12180This is coming from a sharepoint site if that helps and the view i think on the sheet that i am pulling from on the sharepoint is set to 100.https://www.infopathdev.com:443/forums/thread/12179.aspxTue, 18 Apr 2006 16:08:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12179WickedShark0https://www.infopathdev.com:443/forums/thread/12179.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12179Ok so i was able to get the data to pull the right way but now i get 100 rows of empty space. <br /><br />If the there are only 10 rows that match it will give me 90 rows that are blank. Is there a way to fix this?https://www.infopathdev.com:443/forums/thread/12091.aspxMon, 17 Apr 2006 23:10:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12091WickedShark0https://www.infopathdev.com:443/forums/thread/12091.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12091Hi <br /><br />I am designing a form that receives data connections from 2 different sharepoint spread sheets. I am new to this so please bear with me. <br /><br />This is what i have done. My main sheet has most of the information on it and it auto puplutes many areas of the form i am designing based a 3 digit code in a drop down list. This works great. <br /><br />The problem is with the second data connection that receives data from a different form that is for assets being shipped. This data being pulled is simple. There is four colums that i have setup in a repeating table on my form in infopath. They are Asset Tag, Serial Number, Type (of device), and the three digit code from above. Now i can make this work if only one device is being shipped but i need to make this work for multiple devices. <br /><br />Example if i am using the form for code "333" I want it to receive data from the spread sheet that is in share point. So if this spread sheet has 6 devices on it that match code 333 i want it to populate in the form. Right now i can only get it to do 1 and if i click on the insert item button it just repeats the same info. <br /><br />Can anyone help me with how the data connections are supposed to be setup to give me all of the matching rows on the other sheet that match the 3 digit code? <br /><br />Hopefully i am not confusing to many of you.