I have several linking records that involve student teachers, what school they are working in, and what times they are teaching. What I want to do is compare one student’s availability with another student’s availability.
I started with this:
But I would like it to look something like :
I thought about using a formula on my first table to create the information :
IF(Student=“Student 1”, “Yes”, “No”)
However, that returns “No” for everything. How do I set this up so that I can compare two or three students’ availability while eliminating all the extra information? For instance, if want to compare student 1 or student 3, I don’t want to see student 2’s information. (I am actually dealing with 12 students on 5 different days.)
That was interesting, but it didn’t really meet my needs. When I did a junction table, it just added every student to every time, which wasn’t helpful. It might have been useful if I started the database with that intent. I am not sure. I may just have to redo the whole thing. But I was hoping there would be a better way to organize the information I already have vs. reentering all over it again.