I am very new to SharePoint. Management wants a process visible on SharePoint as quickly as possible. We created a native serial workflow in SharePoint and the lists are connected to Access fine. Is it possible to use Access to update the status field of the tasks to trigger SharePoint that the task has been completed and the next task in the workflow can be assigned? I can change the Status field and the % Complete field to Completed / 100.00% but SharePoint logs the following error then rolls the record back to the previous values.
The task was marked as completed but no approval or rejection choice was made.
There is an Outcome field in the History list that SharePoint updates with Approved/Rejected but the field is locked in Access and I can't change that one.
Is there any other way around this or is this a constraint with native SharePoint workflows?