AnsweredAssumed Answered

How to manage portals from two related tables?

Question asked by MikhailSmirnov on Dec 9, 2014
Latest reply on Dec 9, 2014 by philmodjunk

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

Outcomes