I am attempting to display a Teacher Name with a student from our Infinite Campus (Microsoft SQL) database within FileMaker Pro 12.
The 3 Tables in MS SQL are:
Student Roster Section
firstName, lastName come from Student
teacherDisplay comes from Section
A sample student has an ID (studentNumber) of 37972 (studentNumber is in student table)
This student is part of Section 859456
When I manually do the Search in the 3 tables, I get what I want, but when I tried the following ExecuteSQL I have no luck