1 Reply Latest reply on Jul 17, 2013 6:17 PM by PeterMontague

    School database

    PeterMontague

      Title

      School database

      Post

           I'm trying to set up a class sessions portal. I've managed to set up a portal where I can add students by their surname using a value list based on all of the surname field in a different TO. Then first name is narrowed down by a conditional values list based on the surname. The student id is then narrowed down further using a conditional valus list based on a relationship joined by surname and first name.

           So I can populate a class group nicely in a portal which I made. I've noticed that for every portal row I add in the my class group layout a new record is made. But I think this is pretty normal. I've only got two classes so I havent worked out a proper way of making a serial number for each class group. But I've given them, for the moment, the name that they go by in the school. E.g. 1.1A Geography, 2.1A History etc. 

           I'm looking for advice with my class sessions layout. This layout is joined to the class group table by the class name matchfield. I'll change this later. But at the moment I only have two classes. I choose a class from a drop down list and I'd like for all of the students that I have entered in the class group layout to show up in my portal. This is not happening yet for me.

           I'd love to be able to just choose a class and all of the students then show up. Any ideas what I'm doing wrong?

        • 1. Re: School database
          PeterMontague

               I've figured it out. I should have used classgroups::pk_classgroup id instead of meetings::fk_classgroup id in my meetings layout to summon up the list of students.

               My plan is to choose a class group from a list of class groups at the beginning of each class period. Can anybody suggest a way that this could be automated so that depending on the time of day and day of the week that Filemaker chooses the class group for me. Or is this just over complicating things. I guess I could match classgroup id to class group id AND teacher id to teacher id AND time to time. But sometimes the class can start early or late. Is it possible to match using an approximate time?