Hi,
I'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'm running into difficulty is I have written some Code using VSTA, that queries the data that matches 1 field which could pull multiple rows. From there I want each of the rows to be displayed on the form (essentially presenting all rows matching that field to the users).
I've tried to use code to insert the data into a repeating table, however it only shows one row. I'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 bit. Anyone has any ideas?