So I have a SharePoint 2010 List with a InfoPath for m consisting of around 25 columns to be displayed. I also have a Button on the InfoPath which basically does the work of copying all the data of the specified ID back to the InfoPath so that the user can make the necessary changes & submit the form again without having to waste much time in entering the entire data again.
Initailly I was able to do this with the help of Data connections by once the Size of the data in the list exceeded 1000 records it stopped working as the data being pulled was too much. After researching I have found that Data-connections cannot work as a permanent solution for this Duplication functionality as it will have constraints no matter what. Hence I require Step by step procedure to replicate this functionality of clicking a Button on the InfoPath form to populate all its columns from the SharePoint List with the matching ID. ( Please refer to the Attachment for more details ).
