3 Replies Latest reply on Aug 18, 2010 12:52 PM by philmodjunk

    Student Info, Faculty



      Student Info, Faculty & Program  How to setup for drop down boxs?


      I am setting up a Student Info database with Name Address etc with the Program the student is taking.

      On the Student Information form I want to setup a drop-down box that has the Faculty list in it along with another drop-down box that has the Program in it. The student will pick from the Faculty list and then the program box should  include ONLY the programs in that faculty. I can't get this to work.

      I have the following tables:

         Student table with Name, Address etc. and Program

         Faculty Table with Faculty Code and Faculty Name  eg. 1 Education, 2 Sciences etc

         Program Table with Faculty Code, and Program Description eg. 1 Honours Education, 2 Biochemistry, 2   Chemistry, etc

      I have created  relationships:  Student table  Program to Program table Description and Faculty table faculty Code to Program table faculty code.

      On the Student Info form the Faculty dropdown box has a value list from the Faculty Table. This displays properly. The Progam dropdown box has a value list from the Programs table. I can get this box to show all the programs but not only the ones from the specific faculty.

      I'm using FM 10 Pro Advanced on a PC. I'm new to FM but have used other program languages.

      The problem must be in my realtionships or Table occurances somewhere.

      thanks in advance.