InfoPath Dev

 Hello,

 I am trying to write a formula that will filter values for text box controls that match the current Project ID. This example uses the Cost Code associated with the project.

 xdXDocument:GetDOM("Charge Codes")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:CostCode[../d:ProjectID = xdXDocument:GetDOM("Projects")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[../d:ProjectID = xdXDocument:get-DOM()/my:myFields/my:ProjectID]]

It actually works, but now the preview takes way too long to load, and when I enter a different project ID, it takes a long time to switch the cost code. I assume it is because my formula is too convoluted, but this was the only way I could get it to work.

Can someone tell me if there is a more efficient formula? Please see attached image. Thanks.

Hi Metron4,

I would try breaking it apart into two calculations. Do the inner one in the default value of a field which does not appear in your view. Then, the view element can reference that hidden field to do the top filter. See if that's faster.

Just an idea,

Patrick

 Thanks for the reply. Do you have an example of this? I have never set up another view before.

 I was able to accomplish what I wanted by creating a hidden control that stored the ID value. My lookup values now call the ID value of the hidden control saving several steps in the formula. The form loads much faster now.