I have a set of forms in Creator.  They are like the classic teacher / student / class relationships.  One form is the teacher and class pair.  The other is the student / class pair that I need to write a new report using an inner join.

 

I want to read each teacher record and join to the student record using the common class field.  Are inner joins  possible in Creator?.   Must they be sub-forms?

If so what is the script look like ?  (I do inner joins in SQL just can't figure out the creator script to do it.)

 

Hope this makes sense.