i want to create an infopath form that can receive the data out of the slq server database and edit the data in the database and then submit it.
here is what i did so far.
i created a data connection to a sql server database to SUBMIT the data.
also i created a data connection to the same sql server database to RECEIVE the data.
when i open the form the user and the user's details are already filled in the form, now i need to let the user edit the data in the fields or add a new data in a field and then the form need to be submitted to a temporary database to be checked first by
an approver and after approval the form must be submitted to the real sql server database.
i tought about that the approver just need to click a button and the data will be submitted to the the real database.
both the temporary and the real database has the same tables and fields.
i just need to know how to edit and submit the data to the temporary later to the real database
View Complete Post