I've just begun developing a system for my employer- a school- and have been reading and learning so much here. This is my first question- hope you can help!
I have a db called Students, which contains a table for personal details, including a calculated field containing the first letter of the student's last name. There is also a table called school for that info, including a text field for the students year/grade.
My main db- Student Management- has a single table to record incidents relating to that student. The field relationships seem to be working well.
We have almost 1000 students. As a way to quickly find the student you are interested in without typing anything, I have a portal down the side showing all student names, with a script set to display that students records when the name is clicked. To make this quicker, I want to be able to dynamically change the visible records in the portal based on last name and year/grade.
To do this, I have two fields in Student Management called filterName and filterYear- both global fields which have the same data for all the fields in the table. The portal's filter is set to show records like this-
(filterName = Students:Personal:SurnameInitial) and (filterYear = Students:School:Year)
The above does not work. When I remove references to the grade, and filter with only the last name criteria, it works as expected, but if I try to filter further based on both criteria, it still works on name, but modifying the value in filterYear does nothing.
Could someone confirm what the calculation in the portal filter should be? Or, give me ideas where else to look?
Thanks in advance,