AnsweredAssumed Answered

Creating database for a classroom library

Question asked by HimilconInciarte on Jul 26, 2013
Latest reply on Jul 29, 2013 by HimilconInciarte


Creating database for a classroom library


     Hi everyone,

     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!