AnsweredAssumed Answered

Basic Relationship Setup - Teachers

Question asked by briananderson on Mar 18, 2010
Latest reply on Mar 19, 2010 by Jade

Title

Basic Relationship Setup - Teachers & Students

Post

I'm fairly moderately new to FMP10 and I believe this is rather simple to do, but my head isn't working to form it 100%. 

 

I'm trying to set up two separate forms. One for Teachers that show a list of all their Students. One for Students that list all their Teachers.  I've got two tables, one for Teachers and one for Students, that relate to each other via a serial # TeacherID. 

 

When I put together the form for Teacher, using a portal to list the Students (and am able to add new ones), it works great. 

 

The problem is when I want to create a Student form, I get a list of duplicate students (because they are associated to numerous other teachers.)

 

I want to be able to have just a list of students and their associated teachers and vice versa with the teachers. 

 

I know I have some kind of relationship problem or table setup, but I can't figure it out. Could someone point me in the right direction?

 

Thank you in advance!!!

 

Outcomes