InfoPath Dev

What's weird about this is that sometimes it puts a value in the field and its just not the right one. If I open the secondary data source in MS Access I can see the correct information. That's why I'm trying to do it by code because I can't make sense of what the rules based approach is doing.

Hi all, In a repeating section of my form I have a drop down box that lists materials. I use a rule to fill in the associated unit of measure based on the selected material. The rule uses the secondary data source I defined through "data connections". For some reason, the rule does not seem to consistantly fill ...

Done!! Thanks for all the help guys. I thought I had tried it already, but the code below worked like a champ. var objXMLNode; objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees[@empID = '']"); objXMLNode.removeAll(); 

Great..var objXMLNode; objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees"); objXMLNode.removeAll();Thanks for the code. I've started adapting it to my form. I can delete all records in the Employees section using the code above. But when I modify the selectNodes line ...

What I am attempting to do is write jscript to determine if there is a blank row in one of my repeating tables. I removed the ability for users to delete rows but I need to remove blank ones just before I submit to sharepoint and the database. Any hints in regards to how I could do this, would be great.  

I#%92ve been running into the same problem but only at a certain point. The user selects a Business Unit ID and a Contract #, then clicks the ''New SR Number'' button, as shown in the form screen shot below. A stored procedure is called and run to calculate the sequential number where it returns the new service receipt record. All seems to work ...