Student Register/Mark Book
I have a working FMP9 database that I want to improve. My primary layout contains student details such as names, DOB. My second layout acts as an attendance register with date, present, absent, late and their totals through a portal onto my primary layout. What I can't get is to be able to enter the date once and for it to populate each student's record, leaving me to just mark present, absent...for each student.
The same solution should work for my mark book, where I want the title, date set and date due for each piece of work to populate each student's record, leaving me to enter the mark only.
I'd be very grateful if someone could help smooth out this problem.
Will this image help? I just tried using an auto-enter on creation field (probably didn't do it right), but came up with the same problem. Also, would this solution work for the 'Date Due' field in the mark book, as it's a date in the future?
Auto-enter works for the Register, but not for the Mark Book.