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