Creating database for a classroom library
I'm trying to create a databse that will track the "checking in" and "checking out" of books at my classroom library. Right now, I have three tables: Books, Students, and Rentals. I have a field, Books::Status, that states whether or not a book is "available" or "out." I have a button in Rentals (after a book, student, and date have been selected) that, when pressed, sets the Status value to "out."
I want to create another button so that after entering a check in date, the Status becomes "available" again. However, I can't seem to be able to do after hours of trying.
I'm confident I'm missing something essential/basic here, but thank you so much for your help!