We have a .net application and it is a form that users fill records in it and then submit it.
It records the choice for example remote or in person learning.
It could be filled multiple times for a user but the most recent records will be the one that counts.
The form's data goes to Application table : column learningPreference. 1or 0
But I noticed whenever the form get submitted , there is another table data get updated that is student table, column called online value 1 or 0. Because student table is one record each student, it is updated according to the most recent record of the other table's column
So apparently the column of two different tables got synchronized, but I cannot figure out how.
I searched in the html and js code, cannot find it. In database, there is no trigger, no default value or stored procedure for that.
Any idea where else I can look?
Thanks