Hi Everyone ,
In this scenario (Link below) I want to update both free beds attribute in Room table and also Room attribute in student table.
I have 2 problems
1-When I choose a room to update it takes the biggest number of free beds and decrease it regardless of selection but assigns the room correctly to student.
2-As soon as one of the free beds in room table = 0 then all other free beds will be zero in room table . but I dont know why? I mean I assign room to a student and (with the problem above) if now only one of free beds is zero (after assignment) then all other free beds will be set to zero???
https://www.dropbox.com/s/jqxc3hig9i2knvp/Screen%20Shot%202017-07-29%20at%2010.56.24%20AM.png?dl=0
Appreciate any answer to my problem.
Thank you and regards,
