I have 2 Query filters:
The First Query Filter list all the students current classes and levels
I am looping thru this Query Filter one record at a time and providing various information
Since I am now being asked for specific information on the class I have created a second Query Filter
The Second Query filter contains unique records based on the class name and class level.
As I am looping thru the First Query I want to link the current record from the First Query to the Second Query filter based on Class Name and Class Level. If I match on this join then I wanted to assign a Teacher name found in the Second Query to a variable called txtTeach.
I have created both Queries and the initial loop, but I am stuck on the lookup to the second query. Due to the amount of the records in the second query I want to avoid a second loop. Also note my second query is a CAML query from an alternate site. I suppose I could attempt to pass in the Class Name and Class Level from the First Query into the Second Query (CAML query) ?
What is a good approach ?