Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kekewong
Starting Member
6 Posts |
 Posted - 2010-01-24 : 23:06:59
|
| I have a parent table called tb_studentAccount and there are a column name "totalPayment". Another child table is used to store all of students payment transactions and there are join relationship with tb_studentAccount primary key "StudentID" .Is is possible to make something that will automatically update a particular student's "TotalPayment" data when that student make a payment? or this task can be done by only using programming codes in my windows form? Any articles i can have a look with? sorry i am still new in SQL.Kind Regards,kekewong |
|
|
roshana
Starting Member
31 Posts |
|
|
kekewong
Starting Member
6 Posts |
Posted - 2010-01-25 : 00:49:46
|
| Ok thanks will look into it |
 |
|
|
|
|
|
Automatic update parent table?