Need help to build an application for a small library

[hmedh]

Hello,





I am new to your site. My english is poor, so I'll try to make my message clear.

In fact, I try to create an Access application (my first) to manage a small business library. It may seem easy for you, but for me it's a big challenge.

So far everything was old, with cards and records.

To do this, I want to create my database of documents that reach me (SEVERAL COPIES FOR EACH DOCUMENT) and to manage later loans and returns.

I have notions on the tables, the identifiers and links. But then, I do not know how to DECREMENT and INCREMENT the number of copies as loans and returns occurs; create reports out of documents, etc.

In short, I would like to have some advices on the architecture of this application, the necessary tables and how to manage the number of copies left in the library.

Thank you

[ranman256]

In the tDocs table, a field [copies] would get updated via an update query.
or
you can manually update it on a form.

[hmedh]

thank you for answering but I'd like to have more explicit solution. How to build this query for example

Thanks again