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/50767.aspxWed, 20 Jan 2010 04:58:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:50767Qazi Anis0https://www.infopathdev.com:443/forums/thread/50767.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=50767<p>when you create a secodary data connection to infopath list, it fetches all the rows. when you bind them to fields you get an option to filter, there is where you set the condition for the data from which record to be populated in your fields. obviously you are missing the same. </p> <p>If you want only one record to be fetched you will have to write object model code to hit the sharepoint list and get the particular record</p>https://www.infopathdev.com:443/forums/thread/50742.aspxTue, 19 Jan 2010 16:03:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:50742Paddy0https://www.infopathdev.com:443/forums/thread/50742.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=50742<p>I would like to select a single record from a sharepoint list,&nbsp;&nbsp; and use the data to populate an infopath form</p> <p>I have all my fields bound,&nbsp; everything in good order,&nbsp; but&nbsp; the form always pulls the first record in&nbsp;the list.&nbsp; Anyone know how to code this,&nbsp; or is it even possible?&nbsp;&nbsp;&nbsp; &nbsp;</p> <p>&nbsp;</p>