Hello All,
I have an infopath form based on a data source from ms access table. Let's say that the table contains 10 records with the following columns: firstname, lastname, version. When the user opens the form, he will be able to add records but also to modify existent records. What I am trying to get is the record versioning feature: if the user click submit button, all records (if records was added or some modifications were made against existent records) should be submitted again to the database with field "version" incremented by 1. The database should contain minimum 20 records now, 10 with 1 in version field, 10 or more (added records) with 2 in the same field.
There is any way to implement this in an infopath form, if possible, but not mandatory, without code?
Thank you very much,
Costin