Some screen shots;

Cliff - I created a Lookup IDs token as you suggested (created it before the for each, appended it with info in the for each, and placed a token tracker at the end of the workflow).  I appended the student ID to this token, and each was reported.  I then ran the workflow again, but this time appended a piece of info from the database lookup (student last name) and the same name was repeated for each iteration of the for each statement.  I finally concatenated the last name result in the for each with the student id used in the for each, and this is what I see:

In this test workflow, I have created an ID token that contains 3 IDs.  The foreachvalue_iteration shows 3, so I know my for each statement ran all 3 times as it should have.  I can also see that lookupIDs is properly recording each ID each time.  But it is taking the student last name from the first ID and repeating that each time.  Any ideas why that might be the case?

It sounds like you're not using the "current value" tokens like Cliff mentioned above. Could you post screenshots of your workflow activities, please?

I assume you are using the Custom Query or Query Data activities to retrieve the data.  Are you sure the SQL queries are being built correctly to pull back discrete records?  Can you share how you are building your query strings?  Perhaps you can use the same append tokens approach to capture the actual SQL queries that you are sending to the database to make sure the queries are accurate and not pulling back the same record each query?
 

Sure, here is a screenshot.  Let me know if I can provide further details.

Add a Track Tokens inside For Each Value so we can see the values at each iteration.

Chris - It has to be the query or how you are retrieving the values from the query results.  I duplicated your workflow/database on my system and get three records back;

Here is how I concatenated the Return Rows multi-value token to see the results of the query;

Ok, this is strange.  I moved the track tokens activity inside of the for each, and it displayed the concatenated values correctly (different name for each ID).  I then moved it back out to the end of the workflow, and it still displays correctly, even though the workflow is now back to what it looked like originally when it did not work.

So, with technical issues out of the way, I am back to my original question.  I need to see what the 50+ values I am pulling for each ID are.  I was hoping that the tokens tab in the designer would record each set of tracked tokens within a for each activity separately.  Is this not possible?  If not, it would be a great addition to the tokens tab in a future release.  If it is not possible, am I going to have to concatenate each set of 50+ values together into a token so that I can review what each database lookup returned?

If Track Tokens is inside a For Each activity, then you will get one entry in the list in the Tokens tab for each run (with the activity name and the time it ran).

That is great to hear, as that is how I expected it should work.  However, I just placed the track tokens activity back inside of the for each, and this is what I get on the tokens tab:

I see in Cliff's screenshot above that he sees a track tokens icon in the "Select an activity..." window, but I am not seeing that option.  No matter where I place the track tokens activity, or how many track tokens activities I place in a workflow, I only see the two (All Activities) and the [name of the workflow] options.

Can you post a screenshot of the Workflow tab from the instance details? It sounds like your For Each activity is not iterating at all.

Sure, here is the workflow tab:

Here is more of the previous screenshot showing that all three passes through the for each statement were made:

Additionally, here are the activity steps to that effect:

Ok, I found the option under Properties.  For that workflow, as well as the default for all workflows, tracking tokens was not selected.  I have now added that as a default for all workflows.  I have gone back and rerun my original workflow, but I am still not seeing any track tokens icons, much less distinct track tokens icons, on the Tokens tab of the designer.

Try republishing the workflow first.

Just tried republishing/rerunning, but no change.