I may be having a particularly dense day here, however am not understanding how to automate the following situation:
I have four workflow records for each project in a table. There are multiple projects in the table. The workflow records are, in order "project name" Define, "project name" Design, "Project Name" Build and "Project Name" Test. Each has a status of "Not Started", "In Progress" or "Done".
What I want to do is, based on the trigger of the status changing from "In Progress" to "Done" in one task, set the status in the subsequent task to "In Progress". I can select the trigger record without a problem, but how can I move to the next record in the sequence?