AnsweredAssumed Answered

Relationship

Question asked by okten on Apr 3, 2009
Latest reply on Apr 6, 2009 by philmodjunk

Title

Relationship

Post

Hello,

 

I am a new user of Filemaker. I am the director of a graduate program and I am trying to use Filemaker to keep track of our graduate students.

 

I have a table of students - each student record contains several fields some of which are devoted for the student's graduate committee members. The committee members are entered as different fields as: Member 1, Member 2,..,Member 4.  These members are faculty.

 

I have a second table that has the faculty data. Each record has the faculty name, department, etc.

 

How can I set up a relationship and build a portal so that for each faculty I can see a list of students for whom the faculty served as a graduate committee member.

 

For example, if Faculty John Doe was Member 1 in the committee of student X, and Member 3 in the committee of student Y, then I would like to be able to create a layout where I will have Faculty John Doe, and the students X and Y listed as students John Doe served as a member.

 

I will very much appreciate any help!

 

Thanks.

G. Okten 

Outcomes