Button to toggle field
I am doing an attendance tracking program and it calls for a list of students on which to quickly check a person as Present or Absent. The way I desire to do it is to have a field that contains either an A or a P. With one click I want to toggle it between the two. Here is what I have so far:
I made a text field called Attendance. In a list layout, I included that field and made it a button with an If statement that does this properly. The field works great, except it changes all the records because they are a found set (a pop-up menu at the top allows you to select the specific class).
I then tried a portal using an "x" join. It works, but only on the first shown record. If there is only one record, it doesn't work at all.
Can someone give me some hints at what I am doing wrong?
(If someone wanted to suggest a neat interface trick to make it quicker to enter attendance on each student, I am all ears!)
Thanks for the help,