Apologies for the wall of text - this was correctly formatted before I posted.
Using InfoPath & SharePoint 2010 I have a data connection in my browser based form which retrieves a SharePoint list.
The form is a online order form and the list is the full product/price list.
My form is set up to retrieve the data and then load this into a repeating table in the following fashion:
First drop down field - Item type
Second drop-down is populated based on the first (Item description)
I then have several other fields which are populated based on what is selected in the second dropdown. (Product code, Item price, Unit size)
I am currently using default values on the fields for example: xdXDocument:GetDOM("Product List")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Unit_x0020_Size[../d:Description = current()/../my:ItemDescription]
The problem I am having is that when I click the button which will query the data connection and then change views to show the order form I can be waiting for upwards of 2 minutes (With approx 900 items in the sharepoint list)
When I removed all the default value settings then there was no noticeable delay in the query, Based on what I have found searching the web it is all the default values being calculated which are slowing down the loading - What I would like to do is set up a rule on my second drop-down (Item description) set to fire when the value changes so that this then populates the remaining fields. Due to the restriction my Company has placed upon the use of InfoPath I am not able to make use of either Sandboxed or Administrator-approved Solutions therefore I am required to find codeless solutions.
If have attached a dummy form