Need help with archive database !

[spider]

Dear all,

I am new to databases and access but I need to create w simple database, an archiving database.



I have:

1. Closets with closets numbers.
2. In each closet, I have many shelves.
3. On each shelf, I have many folders.
4. In each folder, I have many assessments (referred by a reference number).
5. In each assessment, I have many related documents. (ex. Bill of Quantity, Cash for Shelter, etc...)

I was working on it but with no luck. I have created tables with relationships such as:



Can you please check my tables, relationships and guide me through building forms?

I want to take this database as my initial access training.

Regards,

[orange]

I was working on it but with no luck.

What exactly does this mean?? Error messages??? Wrong data??

Your relationships all appear to be 1 -1??

Seems also that you may need a specific ReferenceTable, and a DocumentTypeTable.

Documents may need more identification, depending on the purpose of the database.

DocFrom, DocTo, DateOfDocument, DocumentSubject

Here is a tutorial on building tables and relationships

[spider]

Archiving.zip

Here is a tutorial on building tables and relationships

Thank you for this tutorial. It gave such a help.
Please check my database in the attachments. Hopefully I made a big progress.
If you have any comments please reply.

Thank you in advance.
Regards,