AnsweredAssumed Answered

How to JOIN on 2 Query Filters

Question asked by davidjohnson5000 on May 16, 2017
Latest reply on May 18, 2017 by davidjohnson5000

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 ?

Outcomes