InfoPath Dev

Hi I find it helpful in these scenarios to think about how I would create a datasource for this and to me this would mean I have 6 fields in the master table and the 7th field is in a daughter table in a one-to-many relationship.  This would give you the repeating structure.  Your current web service just sees field 7 as one field in ...

Hi As explained in a similar post in the database integration forum the problem you have is that the old forms have a "map" for want of a better word of all their fields, data and field lengths, if subsequent design changes the field lengths it is expecting then it will fail saying it cannot locate the row.  The simplest and ...

Hi again so the steps you want to take are 1) User presses submit button 2) Some rules run to email form, then... 3) Set flag One note of caution, if you are sending the form on then setting the flag then you will not be able to submit the form as the "row cannot be located for updating" (for more info search for my post in the ...

Hi The simplest way to keep this data is in a database with the employees second view not allowing submission of any changes in fact once the authoriser has finished you could make all the fields in the employees view read-only, which owuld work too. Or you could link the form to a database to preserve the info and only allow submit to database ...

Hi   The only way to do it is to have a relationship between an AD field and the corresponding field in your other datasource otherwise how does the form know which manager belongs to which employee.  There are two ways to achieve this, firstly 1) In my managers table I would have another linked table on the manager employee ID to a ...

Hi No experience of this but guessing that the upgrade only works visible to one integer ie upgrading from 1.1.3.3 to 1.1.3.4 is fine but 1.1.3.35 to 1.1.3.36 isn't.

OK, to help people who do not yet know what causes this failure I have found that it is due to 2 competing "datasets".  One is the one held by the form and the other is the one held by the database.  From what I can work out InfoPath knows what data you have changed but when checking it with the database finds an anomaly in ...

Hi mum If you have published your form to SharePoint it holds a template copy with all its revisions there. If you have published the form to your c drive it also holds a copy of the template there too. Examine the fields with the stars in design mode of the version on your C: drive and check to see the validation on this form is the same as ...

Just a note that if i have my secondary datasources as XML files the form works perfectly well. If some details get changed then i change the XML and upload it back into the form. The old .XML file is retained as a resource file in the template. I have to manually delete out the old .XML appended files each time i change the XML

Imagine i have a purchase order form which is linked to a secondary data source supplying the goods that can be purchased and price per item. Primary Data Source Repeating @ItemName, @ItemPrice, @ItemQty, @LineCost Secondary Data Source @ProductName, @ProductPrice the customer fills out the order by selecting an item form the drop-down ...