question

Anne-0140 avatar image
0 Votes"
Anne-0140 asked YijingSun-MSFT answered

A Colum in a table is updated from another table

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

dotnet-aspnet-webpages
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

YijingSun-MSFT avatar image
0 Votes"
YijingSun-MSFT answered

Hi @Anne-0140 ,
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.