InfoPath Dev

Thanks so much for your help! I got it working :)

Hi - this is qRules 4.1? What version of InfoPath? What version of SharePoint? We just saw this internally in a 4.1 form with IP 2007 / ShP 2007 - and there is a work around, but I'm wondering if you are using 4.1

Oh, I made a mistake! count (../../OptGroup_EQUIPMENT/EQUIPMENT/equipmenttype[. = "Ladder" and ../EquipInsp = 'Fail'])

What field are you setting the default value on?

So I've gotten a little bit farther with my issue. The formulas do seem to be working correctly, it's just that the fields aren't automatically updating as they should. As a check box is checked the field "quantityA" should be incremented by one. This works as expected with all of the similar forms I have in production now. ...

At first I added it to the database then to the form, but it was unbound and wouldn't submit info. I ended up deleting the unbound form, and as you said, refreshed the available fields via "Data Connections." The new field then appeared in my field list and I added it to the form. That's when submit stopped working.

How did you add the field to the form? If it's a database-bound form, I don't think you can just add a field to the schema. I think the schema needs to be refreshed based on the updated SQL table.

I've been using an InfoPath form for a while without a problem. Recently, I added a field to the database, then went bank into InfoPath and added it to the form. However, when I did that, it broke submit. The option for enabling submission is grayed out and I get the error message "A many to one relationship might exist between two tables ...

Thank you ErnestoM.  That is exactly what I needed.  Works perfect.

Hi- If you want the form submitted to the SharePoint form library and also to a database, you'll probably need to use or write a web service. However, you can just create a database-bound form. First, design your Access table. Then launch the InfoPath designer and go to File > New > Advanced Form Templates >  Database. This ...