I run a music school. I use a Form on our website to provide my staff with a database table of information provided by each potential new student inquiry.
Once our staff contacts an inquiry and marks them as ENROLLED, I’d like to move that student and some of their info to another Table that will allow our staff to view a table of Enrolled students by teacher, date, time, instrument.
I’ve been trying to work our Linking Tables for this, but it doesn’t seem to be working. Just wondering if I’m missing something obvious, or are you unable to Link unique information like the individuals/students name, etc.