InfoPath Dev

I think you are saying you want to copy data from a secondary data source into your main data source? If so, qRules can help with that. But is your intent to be able to update your original data source? That is, when you copy this data into your form from, say, SQL, do you then need to be able to update that existing data? Can you maybe explain ...

Hi -- if Group4 is your repeating group, you should map your table to Group4, then map the fields. Currently, your mapping will only get the first item in the group.

A quick Google search took me to this blog post -- perhaps it can help you? He suggests some configuration changes that may allow you to use the load balanced URL.

This is usually an IE setting. Here is another post on this.

You bet -- you'll need to use preceding-sibling, and here's a sample form that should help you.

What happens if you publish the absence request form to your SharePoint server without making any changes? Do you still have an error? What happens if you create a brand new InfoPath form and try to add user roles? Not sure what you meant by "export to a SQL table" -- if you mean save the data from the XML for the template in SQL, you ...

I misled you, I'm afraid -- I didn't realize that calculated SharePoint columns wouldn't be available in a data connection. Apparently, even if you use an owssvr.dll connection to return XML you will have additional gunk on the string that you won't want. This may be something that can only be done with qRules or code....

No, not in a drop down. Definitely in a text or expression box, but not for drop down entries.

It seems most likely that the unauthorized error would stem from the submit data connection to the lists web service. You may want to try adding another data connection to your form that uses a method from the lists service, see if other lists methods also give you an unauthorized error?

You will always get the first version if the app names are the same. I think what I'd do is have another column in my list that combines the name and the version into a single field and use that for my drop down.