I have an academy data base of students. When a student registers for multiple courses the student will have a record for each class; using an online registration which generates a single record for each class. I need to determine how many lodging rooms are required, obviously a student taking multiple classes will only need one room for lodging. So how do I do this without manually searching hundreds of records?
FileMaker Pro 15