Hello,
I have set up a time sheet using infopath and an access database. The time sheet uses a repeating table to enable staff to allocate time to multiple jobs. The time sheet form works as intended when a staff member uses a new form.
We would like staff to be able to save the from after it has been submitted, so that when they do the next time sheet they do not have to re-enter the jobs within the repeating table, they would only need to alter the date and times.
When we try this and submit the time sheet, we find that we are only modifying the previous week's record, not submitting a new record.
I have searched high and low for a solution, but I have been unable to find one.
Any ideas??