I have two SharePoint lists, one list contains Tools and the other list contains Jobs. On the Jobs List, I enter a new job. I then will select the Tools needed for the job. The Tools are in a lookup field (allows multiple values) that I can select multiple Tool items for the job and adds them to the Jobs List. After you select the Tools needed for the Jobs List they’re populated list the Tools column looks like: tool1; tool2; tool3; tool4;
JOB TOOLS Install door tool1; tool2; tool3; tool4;
I created a workflow with SharePoint designer 2010 I have a basic update list item workflow that changes the Tools List Status Column from In to Out. The work flow only processes the first Item and then stops.
How do I get the workflow continue to process all of the Tools selected to the Jobs list and update status field to Out on the Tools list?
Example: Set Variable: Mytoolsid to Current Item: MyTools
then update item in Mytools