Document Management System

[napster75]

Hi everyone,



Im trying to make a simple document management system anyone can help me and give me some ideas on how to start the design.

Thank you in advance!

[Micron]

Explain more - a LOT more.
Record only the document id's and related info? Retrieve files from a network based on db references? Store the documents in the db? Manage approvals? Manage review prompts?
etc, etc,...

[napster75]

I already a made one table of the database. It will be my document monitoring if its approved, checking the status, manage the revisions and making transmittals. and i found a image in google that gives me some idea of the database i want to build.

[ssanfu]

These might be more involved than you want/need, but they might give you ideas of table structures:

Main Form: http://databaseanswers.org/data_models/index.htm

http://databaseanswers.org/data_mode...ific/index.htm
http://databaseanswers.org/data_mode...eric/index.htm
http://databaseanswers.org/data_mode...ment/index.htm

[Micron]

Based on what you've posted, IMHO you're not ready to build anything yet. You don't want to put everything in one table, use reserved words, have spaces in field names, and you're doing all of that. Here's some links I often suggest for these aspects if you want to improve your chances
Normalization is paramount. Diagramming maybe not so much for some people.

Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.ca/...on-part-i.html
and/or
http://holowczak.com/database-normalization/

Entity-Relationship Diagramming: Part I, II, III and IV
http://rogersaccessblog.blogspot.ca/...ng-part-i.html

How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.ca/...cation-in.html

Important for success:
One source about how to name things - http://access.mvps.org/access/general/gen0012.htm
What not to use in names - http://allenbrowne.com/AppIssueBadWord.html
About Auto Numbers
- http://www.utteraccess.com/wiki/Autonumbers
- http://access.mvps.org/access/general/gen0025.htm

The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html

For what it's worth, I have a complete document AND record management db that I developed in a partnership, but you didn't answer all of my questions so I have little idea if it would be of any use to you.