-
You can't add a filter to a dropdown that has manual choices. You could have two dropdowns if for some reason you want to use manually entered choices - one with all the options, and one with only the options that show when "A" is selected - and use conditional formatting on the dropdown controls to show / hide them appropriately.
-
Under the data tab in the ribbon in InfoPath designer, there is a "resources" button - the XML file is stored as a resource in the form. You can export it from there, and just add a data connection to your form to the same file - it can be added to the form resources when you add it. If you look at the properties for the column B ...
-
See attached. Right click the linked form in the post header, save it locally. Right click the locally saved file and select Design to open in Design mode. Preview to see the filters working. Filter is added to the dropdown selection for the column b dropdown.
-
I think you'll need to at least use a secondary data source (either XML or a SharePoint list) for the second dropdown for "column b" then - will these options change very often? Or are they pretty static?
-
Are you using SharePoint at all? If so - I'd create a list there for the options. I can create a sample for you with XML tho - but I don't understand this sentence: "If any other is select in column in that column a it should be the default value, it should only work only when A is selected"
-
This is something you'll need to use a secondary data source for in order to be able to apply a filter. You can either use an XML file, or, if you are using SharePoint, use a SharePoint list.
-
You have to download it and open it in design mode as per my instructions above: Right click the linked form in the post header, save it locally. Right click the locally saved file and select Design to open in Design mode.
-
I see now. So, you are on the right track with your submit rule - except you are setting the main data source field after you submit, which means the data doesn't get saved. Data entered into a secondary data source (like your XML data source) never is saved when the form is submitted - it will always default to whatever the source data values ...
-
I'm confused, I'm sorry. Are you talking about two separate InfoPath forms? Secondary data sources can be set to query on load or to be queried via rules, which is what I'm talking about. Feel free to attach your form (or forms) to a reply. You can only add one attachment per reply - just reply twice if you have two different forms you ...
-
Is this in FormsViewer or a regular InfoPath browser session? Generally, I wouldn't recommend having that large of an XML file, with 13 hardcoded files in it. I do understand why you are concerned about providing links - If you only showed them the relevant links would that be an issue? That is, are you concerned that if they have the URL to ...