How to manage portals from two related tables?
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?