AnsweredAssumed Answered

Course database help

Question asked by megorama on Aug 15, 2013
Latest reply on Aug 30, 2013 by megorama

Title

Course database help

Post

     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.

Screen_Shot_2013-08-15_at_2.41.37_PM.jpg

Outcomes