https://www.infopathdev.com:443/forums/45.aspxenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/66170.aspxWed, 27 Apr 2011 19:39:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:66170Vrajesh0https://www.infopathdev.com:443/forums/thread/66170.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=66170<p>Hi, </p> <p>I&#39;m hoping someone can help with this, I have an Infopath 2007 form, which I want to pre-populate with data from a table from an SQL DB. That table, as a few categories in it, and theres the potential of the same data being repeated, which is what I want. Where I&#39;m running into difficulty is I have written some Code using VSTA, that&nbsp;queries the data that matches 1 field which could pull multiple rows.&nbsp;From there&nbsp;I want each of the rows to be displayed on the form (essentially&nbsp;presenting all&nbsp;rows matching that field to the users).&nbsp;</p> <p>&nbsp;I&#39;ve tried to use&nbsp;code to&nbsp;insert the data into a repeating table, however it only shows one row. I&#39;m hoping to avoid setting up a secondary data source and using conditional formatting to filter the data, as it slows the form down a&nbsp;bit. Anyone has any ideas?&nbsp;</p>