Course database help
I am relatively new to FM, I am trying to create a course database that has COURSES - FACULTY - LOCATIONS, I succeeded in setting up the database but am stuck. I am trying to have the Course Description layout display only those FACULTY associated with the LOCATION that was selected. I figured out how to have all of the faculty listed but am stuck on how to have it relate to the LOCATION. Attached is my Relationship map. Seems there has to be a simpe answer but I am not finding it.
FOR EXAMPLE: We have faculty in three locations - Paris, Madrid and London, if I add a course and select Paris, I would like only those faculty that teach in Paris to by in the pop-up menu.
Any help is greatly appreciated.