G
Guest
I linked up two tables - one is students fees table and another one is
receipts table. I want to update the student ID fees by entering fees
collected. I have taken the fields - receipt id, date, stu.id, stu.name,
amt.paid, bal.amount, tot.amount (stu.id being the foreign key in receipt
table). When I select the stu.id and enter the fees paid in amt.paid field
the bal.amout has to be updated each time when I select the same stu.id. till
it is zero.
Eg. if the tot.amount to be paid is 5000 and the student pays in
installments each time when I select the same stu.id. the amount should be
updated.
receipts table. I want to update the student ID fees by entering fees
collected. I have taken the fields - receipt id, date, stu.id, stu.name,
amt.paid, bal.amount, tot.amount (stu.id being the foreign key in receipt
table). When I select the stu.id and enter the fees paid in amt.paid field
the bal.amout has to be updated each time when I select the same stu.id. till
it is zero.
Eg. if the tot.amount to be paid is 5000 and the student pays in
installments each time when I select the same stu.id. the amount should be
updated.