Working on a Sharepoint 2010 website with a list of Tasks. The Tasks have a custom field - "Hours worked" which is a number. I have added a web database(Access) site (Contacts Web Database template) which keeps records of the users using the Sharepoint website and completing the Tasks.
1.What is a good way to update the users' record(in web DB) with the "Hrs worked" when he/she completes a Task on Sharepoint?
Currently, I have maintained a separate list and manually add the user the Task was "Assigned To" and the "Hours worked" value to the list.
2.Is there a way to automate this?