Hello all, i have a multi step process for my issues logging form that goes from originator to 1st actioner, 2nd actioner and so on.
Form is submitting to an access Dbase with three tables
d:tblusers with primary field 'User No' that has a one to many relationship with the second table d:Tbl_FSSIssueLog with it's primary field 'IssueNumber' which in turn links to d:Tbl_Progressing with its primary field of 'Progress Number'
The originator fill in the form to raise an issue, they select who is repsonsible from a list and mail it to them using a button with rules.
The next person opens up the attachment and adds further actions or comments, with the option to pass the buck onto someone else. If they do pass the buck they type in an email address and click a button to seubmit as email, and sumit changes back to main datasource.
It passes the email step with almost no problem( I have to close outlook before it lets me email it on?!?!?!?) then gives me this message when trying to update the database. IInfoPath cannot submit the form.
An error occurred while the form was being submitted.
[0x80040E38][Microsoft Cursor Engine] Row cannot be located for updating. Some values may have been changed since it was last read.
I have read quite a few posts but can't seem to get this to work.
This is my 3 or 4th such workstream and have had no problems before but am stumpted on this one.
Cheers Adam