AnsweredAssumed Answered

Band and Orchestra Attendance Help

Question asked by builder on Apr 9, 2009
Latest reply on Jul 14, 2013 by PeterMontague

Title

Band and Orchestra Attendance Help

Post

Hello,   

    I am fairly new to Filemaker (using version 10). I am trying to make a attendance list for music students enrolled in band and orchestra. So far I have the following.....

 

Student Record (studentID, name, instrument, grade, ensemble, etc.

 

Band Attendance (Date, bandIDfk)

 

Orchestra Attendance (Date, orchestraIDfk)

 

I have the tables related between the ensemble field and the repective bandIDfk and orchestraIDFK. The ensemble field is not a unique id (though each student has a unique id), it is a check box list of Orchestra, Concert Band, and Jazz Band. 

 

I then have a portal in each attendance layout that lists all the students' that have that ensemble selected in their student record. 

 

It displays the information exactly the way I want it too, But I thought I could add a "Present\Absent" field to each portal and have a checkbox display to take attendance, unfortunately they all get set to the same value which makes sense.... 

 

How can I added a field in the attendance layout that will give me the option of selecting a present\absent for each student record?

 

I hope I am explaining myself clearly.

 

Thanks so much

 

Outcomes