have a parent table called "Teachers" and a child table called
"Teacher Activities," which tracks a variety of records for each
teacher, including the lessons they have taught so far this year. I am
wondering if it would be possible to create a field in the "Teacher
Activities" field that would number how many lessons that teacher has
taught so far this school year, e.g., this record is the first lesson this
teacher has taught, the next one would be the second lesson, etc.
The records in "Teacher Activities" are sometimes uploaded manually and sometimes uploaded with an Excel spreadsheet, and the record IDs are not in order based on when they're taught.
I do have a "Date" field that tracks when the lessons were taught, and I would want to use this to determine the ordinal number.