High, I am creating a document approval workflow in sharepoint designer 2007. We currently have WSS 3.0 deployed in a small sharepoint farm .
Set up is a followes on the SharePoint site:
First list is called Pending. Second list is called Approved, third list is called rejected and forth list is callled Tasks. There is also another list created by SharePoint when setting up the workflow called Tasks1.
OK, so in SharePoint designer I have the following workflow that starts auto when item/document is added to pending list. An e-mail is sent to a certain user telling them they have some documents to review and a copy of the item/document is placed into Tasks1 (I deleted the tasks list as I thought it best to use the task1 list sharepoint created)
Also to note I created a 'status' field in tasks1 list that has a choice/drop down menu of Approved or Rejected.
Now what I want to do is the following, but not sure how to do it:
When person changes the status field on the document in tasks1 to either approved or rejected the item is coped either to the respective list 'Approved or 'Rejected' and the document in pending and tasks1 is deleted. I've tried a few commands but cannot get it to work. What actions/conditons should I be using.