InfoPath Dev

Okay I found it, it seems that I get the error because I don't have proper credentials to access that database which is fine, I can fix that

Okay that fixed the issue of not being able to add a new form in the browser. THANK YOU SO MUCH :D Where is the Event log on the server?

Is your document library set to use content types? Is the newly admin approved form a content type you've made available in this document library? Is it the default content type? Your first bullet point makes me think that your form library is NOT set to use content types. If your form is admin approved, you'll need to set the library to ...

I'm so glad it is up and running for you. I tend to actually work from the form source files a lot - so I just manually change my mapping and move on. If you ever wonder if the issue is the mapping, you can export it under the Resource Files (data tab in IP 2010, Tools menu for IP 2007) and then open it in a text editor and take a look at it.

Okay so we've done a few more things and here is an update:  We started a brand new test server and copied the devilish form onto that machine, published it and got it approved and activated (seemingly) and all that but it still doesn't seem to be working properly. The form is in the Form Templates library, and is activated and ...

Hallelujah!!!!  Oh my gosh it worked...I am sorry I was updating the form everytime with the new mapping file; not sure why it didn't take.... things that make you go hmmmm.  I will be taking this to the powers that be so that we can order it.  Thank you soooo much for your help.  BTW I am an InfoPath Enduser Trainer and ...

OK, I have the formatting accomplished.  I set a "kit" check box in my table.  Sub items are checked by default (value of 1). Sub items also have the same "GearID" as the main item (all other, individual, non-kit items have unique GearIDs).  When a main item is ordered ("need" = or > 1), I run ...

Never mind.  I needed to concat in the field.  Here's what the formula that works looks like - concat("SetValue /xpath=/my:myFields/my:Pullsheet/my:PullSheet/my:Kit[../my:GearID='", GearID, "'] /value=0")

Awesome, that fixed it. I never would have thought of the postback, thank you!

You need to update the mapping file in your form with the new one. The mapping in this form is the old one w/out the parent fields. Just walk through the mapping data connection again, and use the new mapping file for the data source.