A bit confused with tables and relationships (1 Viewer)

[marleyuk]

Hello, ive done a bit of access before but ive got myself a bit confused on my next step.

I have a database of books that i loan out. I have a table containing the books instock. I want to be able to loan out book s and reserve books. The problem is whats the best way to do this? Should i have a form that allows me to click a button that takes the book out of the books instock list and adds it to the reserved list? The problem i see with this is when all the books had either been loaned or reserved then the books instock list would be empty and nobody could reserve anymore books which would be a vital floor. Does anyone have any ideas?

Thanks,
Marley.

 

[JonyBravo]

Hi!

I don’t know if I understood properly what you want to do but if was me I would do like this:
If a book were out I would put it in the reserved list with available dates. After someone reserves any book on certain date, that date would not be available to reserve anymore.
Hope this help you.

JonyBravo