A Colum in a table is updated from another table

Anne 276 Reputation points
2021-07-08T20:52:27.823+00:00

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

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,254 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yijing Sun-MSFT 7,066 Reputation points
    2021-07-09T05:20:12.357+00:00

    Hi @Anne ,
    How do you write your data? SQL Server database? And how do you show your data in the code of the application?
    Could you tell us more details of your codes? You could post full codes.
    Best regards,
    Yijing Sun

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation  to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments