I currently work for an online school and I want to be able to track all of my students. Specifically, we have different employees to track different topics (one for math courses, one for english courses, …) and records the date they checked the students lesson notes, attendance, etc… We also have one employee who tracks all students and reaches out to the students on a regular basis who records the date of their interaction and when they expect to contact them next.
Ideally, I would like each employee to have their own table in the base where they can only see the the associated students and be able to change dates. (On top of other tasks I’d like to do on it, but those aren’t a priority right now/can figure them out after this issue is dealt with)
Currently, I can’t make that a reality without manually copying each additional record to every single tab (even if using links/lookups). Is what I’m trying to accomplish even possible? Here is a picture of my main table which includes the student’s name written on multiple rows for different classes: