Hey Patrick, maybe you could try creating that concatenation you mentioned of school + class for both the School and Students tables, create another table called Classes, and then link everything together via that value with automations? You’d then be able to pull over the survey value via a lookup field

Thanks a lot @Adam_TheTimeSavingCo that’s very very helpful!
One question for you… when you create the “link to table school” on the classes table, do I need to pick the school every time ? Or can it be automatically recognized ?
That’s my concern, is that I still need to manually select the school each time.
Or am I mistaken?

Thanks a lot!

You’d use an automation to link it up, and it’d depend on where your records were being created

For example, if your records are primarily being created in the Students table, then you’d have an automation that would trigger when a record in that table’s Classes field was empty and its Concat field was not empty, and the action would be to paste the value in the Concat field into the Classes field, which would automatically link them together, does that make sense?

It makes perfect sense !! Thank you very much again for the help, very appreciated!