I have a table that is called books. In this table it contains all the 'books' avaliable in the 'library'. A field in this table is called onShelf. When it is checked, it means the book is on the shelf, when it is unticked it is currently 'issued'.
On the book issue form i currently run the query, "SELECT bookID FROM tbl_book WHERE onShelf=true". This query works fine and in the drop down combo box it shows all the books that are avaliable to be issued. The problem is, when i issue out a book (onShelf is unticked) the book title disappears from the Issue form because it is no longer onShelf.
I am completely brain dead trying to think of a solution to this problem, hopefully some expert here has a simple work around to this problem, If you don't understand what i mean ask question and i'll see what i can do
On the book issue form i currently run the query, "SELECT bookID FROM tbl_book WHERE onShelf=true". This query works fine and in the drop down combo box it shows all the books that are avaliable to be issued. The problem is, when i issue out a book (onShelf is unticked) the book title disappears from the Issue form because it is no longer onShelf.
I am completely brain dead trying to think of a solution to this problem, hopefully some expert here has a simple work around to this problem, If you don't understand what i mean ask question and i'll see what i can do