make two textfields
dummy_a, global, = "A"
dummy_p, global, = "P"
and them make two joins from your table, to your table itself.
from field dummy_a to person_is_present (or however you have named the field), = (but not cross)
name this instance of your table xyz_is_absent
from field dummy_p to person_is_present, =
name this instance xyz_is_present
ét le voilá *1), the work is done.
greetings from germany
*1) to Hugo: i hope you can read french.
The field works great, except it changes all the records because they are a found set
I would suspect that it changes all records because the field is global (or that you are using Replace Field Contents in your script). If you are using script similar to:
Set Field [ Attendance ; Case ( Attendance = "P" ; "A" ; "P" )
... and if Attendance is not global (and is text) then it should properly toggle. You might wish to set up the Attendance field with default entry of P (since hopefully most students attend class) and then you'll only have to go through the list and toggle those you have identified as Absent. :smileyhappy:
UPDATE: Oh, and you should disallow entry to the field in Browse mode (see field behavior).
Yes thanks Kapitaen!