library management system

[mrrul3z]

i am making a school library mangement system as a part of my project work in school, iam in 10th grade, and supposed to make just a beginner project.
there is some stuff i need help with,
i have made three tables,
members
books
issue
issue table consists a field of return for yes/no to indicate if a book has been returned or is it still loaned. i want a query where i could display the books that are available excluding those that r lended,
how would i do that?

 

[statsman]

i am making a school library mangement system as a part of my project work in school, iam in 10th grade, and supposed to make just a beginner project.
there is some stuff i need help with, i have made three tables,
members
books
issue
issue table consists a field of return for yes/no to indicate if a book has been returned or is it still loaned. i want a query where i could display the books that are available excluding those that r lended,
how would i do that?

My young friend, you are dealing with adults here. You are making a post on a technical forum not on Facebook or on your PDA. The reason I bring this up and point out your errors to you is because spelling counts here. A minor spelling error could result in a total misunderstanding of what it is you are trying to say.

OK - lecture over.

What you require is a method of entering your data when a book is loaned. You then need a separate method of updating the record when the book is returned.
I would suggest you use a form for both functions.
The first form enters the loan information (the member, the book and when the book is due back).
The second form updates the data in the first form to indicate the book has been returned. I would use a search form before opening this form to allow you to find the correct loan to update.
Your Issue table will be more difficult as you will have to enter the total library in order to accurately see if a book is available or on loan (I am assuming there is more than one copy of some books).

Good Luck