AnsweredAssumed Answered

Student Info, Faculty

Question asked by JimRoney on Aug 18, 2010
Latest reply on Aug 18, 2010 by philmodjunk


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.