I have a custom input form that updates a sharepoint work order list. Ultimately, I would like to get the Work Order list data into SQL.
I created an external work order list that updates a SQL work order table -- it works. The external work order list and the sharepoint list have almost all of the same fields set up.
1) Is there a way to have the work order list update the external list (and the external list would automatically update the SQL table)?
2) Should I change the custom input form so that the form updates 2 lists at the same time - the sharepoint work order list and the external work order list (and the external list would automatically update the SQL table)?
3) There is a better solution ? :-)