Tracking Work with Lookup Records

I’m not quite sure how to do this but feel like there is a way in AirTable so I wanted to ask…

I have a Base with three different tables filled with people. In Table C, I have a list of teachers that I have linked to a school leader, Table B, and in Table A, I have a list of District People that are linked to Teachers in Table C.

Records are created in each table based on specific conditions.

How can I help my team track their work?
For example, if they go to Table A and lookup all the teachers associated with a district record on Monday and then a teacher that should be linked with the district record gets added on Tuesday, how can my team when they check on Wednesday distinguish between the teachers they saw on Monday verse the Teacher needing to be added on Tuesday?

Hope this makes sense.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.