InfoPath Dev

Hey there, I feel like this question has been asked and answered already, but I couldn't really find anything. I'm looking to concat two dataFields pulled in from SQL into a single text field. It's simply grabbing a Site and their Comments all into one field, but the two fields are repeating data. When I try and do a standard concat(../dfs:dataFields/d:program/@Site, " - ", ../dfs:dataFields/d:program/@comments) The data won't repeat the data even if placed in a repeating section. I'm expecting something like: PA - These are my comments NY - Here are my comments But I'm just getting PA - These are my comments PA - These are my comments I saw some topics using eval with concat, but I wasn't sure what the purpose of that was. Thanks!

You'll need to create a repeating control (table or section) that is bound to the secondary data connection.  Then inside the repeating control you can create a calculated value control whose value is the concat of those 2 fields that you mentioned.  That should allow the data to repeat rather than only give you the first row.

Eval only works for when you want to concat repeating data into a single line of text, which I don't believe is what you want.

Oooo, that makes sense. Awesome, everything worked out. Thanks!