Facing problems with Node Relationships due to lack of technical knowledge

Hi, I'm trying to create a basic Library Management System using Drupal 7. I have created three content types- Books, Students and Circulation. What I'm trying to achieve here is that I need a view named "Book Status". When user clicks on book status and types in the Book Accession Number (the title of the book content type), it should display the availability of the book in the library and show a link to issue the book or return the book accordingly.
Circulation is a content type which takes the Book Accession Number, Student ID, Issue Date and Return Date. So the Book Status should reveal the availability depending on the last circulation of the same Book Accession Number. If it has a return date, it is available and issue button should be active, if it does not have a return date, it is unavailable and the return button should be active.
I'm not at all a technical person, but when I started using Drupal I realised that this is an easy interface to use for people like me, but here I am stuck. I have no idea how to accomplish this. Please help me out people.