My scenario for the workflow in SharePoint Designer is that i want to create a
workflow where on my site
i have 3 custom lists Tests, Reviewers (Columns: ReviewerName, Sequence# )and
Approvers (Columns: approverName, Sequence# ). If any item is added in Tests
then the workflow must be started and the user in the Reviewer list with
sequence # 1 must review it. If he passes it then the user in the Reviewer list
with sequence # 2 must review it and so on . After the users of the Reviewers
list the users of Approvers list with sequence # 1 ,2 3... must approve it
respectively.
Problem is that workflow works fine for single Reviewer and Approver but how to
assign the task to the users in list on the basis of sequence in the workflow.
any help will appriciated (I know it can be done in Visual Studio but how in
SharePoint Designer)