Hello

I hope I didn't miss any threads on this, but I think I read everything related to arrays on the forum.

My scenario is a single table with

a callID field ASC number (not unique)
a sequenceID field ASC number(unique)
a teadID field string

For all same callID's I want to populate the array with the sequenceID which is associated to the corresponding callID while the teamID is equal "TeamA"

or in other words:

for every sequenceID with the same callID I want the array to be updated with that sequenceID as long as the teamID is equal to "TeamA".

When the callID changes I want to find the highest sequenceID and use it to identify the corresponding team record information and print it, and then move onto the next callID and re-iterate.


thank you for your help