4 Replies Latest reply on Dec 9, 2014 7:52 AM by philmodjunk

    How to manage portals from two related tables?

    MikhailSmirnov

      Title

      How to manage portals from two related tables?

      Post

      Hello everyone,
      I'm trying to create a part of our English Language School database (for FileMaker 13 WebDirect) and need help.

      I have two tables: Students (List of students) and Host-Families (List of accommodations). Every student could rent host-family accommodation, then change it to another host family.

      So, for each student could be many Host-Families and for each Host-Family could be many students.

      I need to be able to manage: On student page - "portal with list of student's subscriptions for host-families", and On Host-Family page - "portal with list of student's subscriptions for this Host-family, with ability to calculate Total monthly payments"

      I created two new tables "Host_Index" and "Host_Reservation" with "Students" Table many-to-many relationships. On Student page I created portal with Drop-down list of the Host-families field  "Family name" but it works only for students, I can't manage student's subscriptions on Host-Family page...

      Are there any other ways to manage this?

      Thanks.

      Database_Structure.jpg