-
This blog entry by Ben Walters has a really nice explanation of how to do this. Why don't you check it out and see if it helps you?Post back if you get stuck, okay?
-
No, that would only affect xml files created with previous versions of the form. Try walking through the data conneciton wizard again for your main data connection (select the main connection from the data connections window and select modify) and make sure everything looks correct and that submit is still enabled.
-
Hopefully your SharePoint list isn't huge -- also I think the data returned from ShP is going to depend on the number of items displayed in the default view. However, you certainly can do this the way you propose -- the drop down control can hold your list of vendors and be bound to the main data source. The repeating table can be bound ...
-
Actually, the blog post uses SQL, not SharePoint.
So you created a new data connection to your database -- does it have an ID column? You should set the data connection to query when the form opens. Set a default value on the field in the main data source where you want your ID. The formula for that value should use the max function to get the ...
-
You can still expand the form files. Take your .xsn file and rename so that the extension is .cab instead of .xsn. Then open the .cab and copy out the files. You will then have manifest.xsf that you can open and modify.
-
It isn't having more than one table that prevents you from submitting. If the form isn't allowing you to submit, it may have to do with the relationships between those tables. From Office Online:
When you connect an InfoPath form to a database, note the following issues:
When you connect the form to more than one table in the ...
-
Generating Id's can get a bit tricky. You can find different approaches -- a lot of them use code. If you are storing your Ids in SharePoint or SQL, you can always run a query to retrieve the Ids and use a formula like Max(Id field) +1. However, this isn't fool proof -- you can always have an issue of more than one form using the same Id ...
-
Conditional formatting is not in the rules section. If you are in the button properties, I think it is under the 'Display' tab. So you use rules to set a field's value, then you base conditional formatting off that field's value....
-
Are you in the Manager view in design mode when you preview? IP seems to always open to the view you are designing when previewing....not the default view, as might be expected.
-
The form you can't submit -- was it created with a previous version of the template? Is your template set to upgrade automatically when you open an xml created with a previous version? Or do you mean you can't submit newly created forms when you use your template?