8 Replies Latest reply on Aug 6, 2014 9:29 AM by philmodjunk

    New learner frustrated with "many-to-many" portal

    TonyG

      Title

      New learner frustrated with "many-to-many" portal

      Post

           I've been learning FM on and off for about a month, now I'm stuck.

            

           I have 3 tables (Student, StudentClass_Join, Class) for a "many-to-many" relationship. I made a layout based on Student, and on the left-hand side I insert a portal controlled by a drop-down list to list all the students registering a certain class. When clicked, an individual name on the list will show the detail information of that individual on the right-hand side.

            

           The Problem: Only part of the candidates registering that class will show up on the portal list.

            

           The portal filtering design is based on the article http://filemakerinspirations.com/2010/10/dynamic-portal-filtering-while-you-type/

            

           I believe there is something I didn't understand and make it right with "many-to-many" relationship, just don't know Where and How to correct it.

            

           Forgive me for the newbie question. Any ideas would be very helpful, and, if you could, please give some details for me to understand.

            

           Thank you very much.

           I don't know how to attach my file here, so I just give some screenshots.

            

      6.PNG