AnsweredAssumed Answered

Portal doesn't work when join tables used?

Question asked by DarenKalahan on Oct 4, 2010
Latest reply on Dec 29, 2010 by Abhaya

Title

Portal doesn't work when join tables used?

Post

Hi there,

To try and remedy my issue in the bigger database, I created a simple database that mimics the issue. Please see attached photo for table relations created.

Three tables:

Teachers

Students

Classes

All are many-to-many relationships so I've created join files between each to make them one-to-many.

Goal: Include a portal in the teachers form that lists which classes a teacher is teaching. Whenever I include a portal though and view it in "Browse Mode > List View" the result is blank.

When I include a portal in the classes form to show students in the class, on the other hand, the portal works.

What would you recommend?

I'm a newbie.

Thank you so much for your help!

FileMaker Pro Advanced 11

Screen_shot_2010-10-04_at_7.16.21_PM.png

Outcomes