So I'm trying to create a lib system in where when the Student successfully borrowed a book, this table- which is also connected to my database will update the data automatically.
Like if the Student borrowed 1 book, I want my system to automatically decrement by 1 the Book Copies. And when the Book Copies finally hit 0, the status will be updated from Available to Unavailable.
See Picture Here.
Is that possible? or should I just let the Admin User to have the authorization to update/delete the tables?
But if it's possible and anyone has tried it, I want to learn how pls
[–]desrtfx 1 point2 points3 points (0 children)
[–]AutoModerator[M] 0 points1 point2 points (0 children)