-
When you create the main data connection. There is a dialog for adding additional child tables. If you want to submit to two parent tables, you may need to create a Web service. Qdabra provides a free trial of our popular DBXL Web service which can support this scenario if it's the same database. Check out Qdabra.com and click on Web Services ...
-
We don't have dynamic SQL queries out of the box with InfoPath, unfortunately. Your options are writing code, building or buying a web service (DBXL, for example) or qRules also has commands for this.
-
You should be using "auto" for one of the dimensions.
-
You should be able to create a join between multiple tables in your main data connection -- is that what you are asking?
-
How about using a Calculated Value?
-
-
The issue with a multi-select is that it inserts a new instance of a repeating field when checked. InfoPath offers no way to do this outside of code (you could also do it with qRules).
-
Are you using 2007 or 2010? In 2010, a SharePoint List connection has query fields which may help with this.
-
No can't do that. It's a document so when a user opens it, they will lock out the others from editing. I recommend splitting the views into different forms.
-
This really seems like it might be a rule someplace in your form that is re-setting a value.... Have you checked the field in the rule inspector?