InfoPath Dev

The reason its not allowing the Submit option is one or more of the tables in the data source do not have a primary key, unique constraint or unique index

I have created a new form from Data connection option and dragged acorss the query and data fields - all good at this stage. i now want a submit button at the bottom that will allow user to submit the values back to the database. But i dont get an option to submit it back to the database. I create a button and in the properties i change the ...

i have created an apporval form with 3 different views. i want to implement an audit log which will keep track of approval stage with time e.g when submit is clicked - audit log should look like Submitted by 'fieldname:username'on 'time'. when approve is clicked - audit log should look like Approved by 'fieldname:username'on 'time'. i dont want ...

Agni - could you explain more on it please (if possible with an example). Thanks

I figured out the problem associated for not switching to the last view. 1. When a button was clicked in any view it makes the ''view'' condition True. for example: If i'm submitting the form - on click i make the value of submit to true. for Approve - approve is true, etc 2. On Form Options (Open and Save) i was checking if the value of ...

Thanks Shiva i already know that (doing so for individual controls) - i'm looking to make it read only at form or view level or any other way apart from each individual control properties

I have created 3 views (Request, Approve, Decline) and i would like to make Approve View read only (except an Approve & Decline button). Is there any way to make Approve View read only (except an Approve & Decline button) - other than making each individual controls read only? If so, how?

Thanks Shiva - but i want the solution using rules. Seems that if i make the new form with the same concept then all works fine. May the old form had something in it from stopping it to switch from Approve to Deny.

If you do it from Button Properties then it changes the View then and there - But a normal user shouldnt have that authority to change the views. The data gets submitted to user a Data Connection (emailing to the Line Manager). And when Line Manager opens the Form the view is changed to Approve.

i'm creating a new request form with 3 views (Request, Approve, Denied) where a user fills in the required information and submits to the line manager (Request view). Line manager have a different view (Approve) which he can approve or decline the form. On approving it sends and email out to the designated person inchange of providing the service. ...