AnsweredAssumed Answered

Basic Relationship Setup - Teachers

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


Basic Relationship Setup - Teachers & Students


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!!!