InfoPath Dev

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 ...

Hello I have the following two dropdown below: Column a drop down: A,b,c,d Colunmb b dropdown, 1,2,3,4,5,6,7 When A is select in column a, hide 2,4,6 and show 1,3,5,7 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. Any help will be highly appreciated.

Here is the form. Hope this helps better understand what I am trying to do.

Sorry for the confusion. I wish I could attach more pictures to better explain myself. By two forms, I mean I have two views, as you can see from the attached picture. The default one has fields from the main data source and secondary data source, while the non default view has fields from the main data source.

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 ...

The form that is first viewed when an item is created has the secondary data source. After that form is submitted, I made sure to add that same secondary data source in the other form, but in this other form the secondary data source field is blank. I don't know why.

Im not sure what you mean by "does the form always query the secondary data".

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 ...

Does the form always query the secondary data source? When you use a secondary data source as a default value in the Main data source with that "refresh" checkbox selected, you'll need to make sure the secondary data is always present. You can test that by putting the secondary data source field on your form in the views you wish to ...

I have a form that has 13 embedded documents that brings back up to 2 of the 13 potential reports which range in size from 400KB to 1400K. After several minutes of trying to open, the system brought back this error “An error occurred trying to load the document at /its/infopathwf/SOC/11016_SOC_BSmith_2021-11-17.xml - Failed to fetch - The form ...