Creating a classroom seating plan
I've searched the internet and google has let me down.
I currently have an Excel spreadsheet (link) that shows the desks in my classroom and the students names. Each cell on the seats sheet points to a cell in the pupils sheet. If I rearrange the pupil list (e.g. as the result of an exam) the seating plan can be updated automatically.
Is there some way of doing something similar to this in FileMaker? Ultimately I would envisage clicking on the student's name in the seating plan and going to the record that showed the data such as test scores and attendance, held on a separate part of the database
Thanks in advance