InfoPath Dev

Hi - I'm trying to load data from a SQL database on the "run query" command. I have other fields populating correctly (with people pickers), but for one field where I can have multiple values, it only loads the first one. What I need is a way to load the data from a table based on the appID of the currently loaded object. The table matches the appID to a contact name. So, I have an object with 2 tech contacts - so in the table it has the appID of 0 for two rows and two different contact names. Each of these should load into its own people picker within the repeating group. In my case, only the first is loaded. Am I doing something wrong? Thanks in advance.

Hi:

You aren't doing anything wrong -- you've run into an InfoPath limitation.

There is no out of the box way to copy repeating data from your secondary data source into your main data source (i.e., add another element, populate the values).

Your choices are to write custom code for it or you could try qRules (we've written the code already and make it easy to use).

Sorry to be the bearer of bad news....

Thanks for the response Hilary. I'll look into my options.

Thanks for your response Hilary. I'll look into my options.