https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/107331.aspxMon, 11 Jul 2016 19:55:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:107331Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/107331.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=107331Wonderful, glad you found a solution - BTW, if you use Internet Explorer, the forum will leave your formatting alone. Sorry for the inconvenience - this is an older version of Community Server and it struggles a little with modern browsers.https://www.infopathdev.com:443/forums/thread/107327.aspxMon, 11 Jul 2016 13:08:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:107327Richard Hill0https://www.infopathdev.com:443/forums/thread/107327.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=107327While I normally would not answer my own post I have actually worked out how to do this and thought I would both share this knowledge and to save the time of anybody who may have answered. I have set up a rule on my second drop-down which sets the value of each of the other fields to the relevant field in my dataconnection filtered using the following expression "../d:Description = current()/../my:ItemDescription" This has reduced the view loading times from 2 minutes plus to around 7 seconds.https://www.infopathdev.com:443/forums/thread/107325.aspxMon, 11 Jul 2016 07:31:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:107325Richard Hill0https://www.infopathdev.com:443/forums/thread/107325.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=107325Apologies 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