InfoPath Dev

Hi Ive been using Infopath for a number of years now and we even purchased DBXL v2.4, although i purchased it as it came with Querydb and Active Directory Web service which i use in the form. I have one large Change Request form which is attached to a SQL database and gradually over the years the form has become more complex as ...

 So are you saying that this issue only occurs if the form is saved? In that situation is it correctly saved with the first available ID or is something going wrong? It seems like in any case you need to remove the restriction to prevent overwriting documents, because that is preventing you from submitting.

Well - I don't know what is going on, but here are some troubleshooting ideas.If you have a user with this issue try the form on another computer, what happens? (That is - is the issue machine based or user based?)When the issue occurs, have the user hit Ctrl + Shift + O (letter "o"). This brings up a dialog where you can click Show ...

 Thanks Hilary,   That worked

We built a form in Infopath that sends the data to our database in MS Access. Some of our users on our network cannot submit the Infopath form. Those users are always getting the error "Please fill out required fields" but all of the fields are complete. Why do we get this error and why only with certain users? Thank you!

I am not sure a default value would work for the isRemoved field, but I could do a filter on the partNum field in Table 2 to match the partNum in Table 1 and mark the isRemoved field for that specific row. Only problem is, I can't figure out how to filter that way.  

This is a challenge in InfoPath. Your rule is going to set all instances of isRemoved because it is on a field outside of the repeating group. You have a few options. One is you could use a default value for isRemoved in Table1 - then you could use an XPath filter to see if any instance of the part number is in Table2 with isRemoved = yes. Would a ...

Does anyone have any ideas on how to get this working?  Pretty pretty please?