SharePoint Workflow Issue (built with SPD)

I am currently having an issue with a workflow that is based upon contect types and "approval" fields. There are two lists - Project Documents & Project Checklist. The project document section has 12 different content types that are project documentation templates (charter, request, plan, etc). In this section there are 5 choice fields for approvals. In the checklist list I added individual choice fields that are based upon what stage the documents are in (Draft, Approved, N/A). Also each these lists reference a specific project (title field located in another list). The workflow I create (using SPD) resides in the checklist area and for each content type in the project document area it should alter the choice field in the checklist area (see attached). However, the workflow only alters the item that was created first for each individual project. So if the charter was created first the plan was created second and the request was created 3rd, it only alters the choice field in the checklist for the charter. However, if I delete the charter and run the workflow it will now only update the choice field in the checklist for the project plan. Please help....
workflow.JPG
JMSTechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JMSTechAuthor Commented:
So I tried a different solution. I instead added calculated columns in the project document section that return Content Type-Approval State. I then built the workflow (see attached)  based upon this new field however, the workflow created a new issue. Instead of just altering the first field in each item it now allowed for only one item in the list to contain one choice. In other words If project plan was "Approved" for one project (list item) project plan could not be "Approved" in another project. Suggestions....
2nd-Attempt.JPG
0
JMSTechAuthor Commented:
while I couldn't find a solution for this individual probelm, the easier option was to associate the workflow with the document list rather then the checklist. it now works.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.