Table Design - Probably Very Simple

[MadCrazyNewbie]

Hey Group,

I wonder if somebody would be kind enought to help me on this little
problem, well not quite a problem, i just don`t know how to design this:

My Senario: I have 20 Document Catogories, Each with 10 Sub Catagories, each
of the 10 Sub Catogories has a 10 Documents

How would i design my database for this?

Many Thanks for any help

Regards
Simon

 

[Lynn Trapp]

Try something like this.

tblDocumentCategories
CategoryName (Primary Key)
....other fields needed to describe a document category

tblDocumentSubCategories
SubCategoryName (PrimaryKey) -- Assumes SubCategory names are unique across
all Categories
CategoryName (ForeignKey)
....other fields needed to describe a document subcategory

tblDocuments
DocumentNumber (PrimaryKey)
SubCategoryName (Foreign Key)
DocumentTitle
....other fields needed to describe a document

 

[MadCrazyNewbie]

Many Thanks Lynn

Regards
Simon

Try something like this.

tblDocumentCategories
CategoryName (Primary Key)
...other fields needed to describe a document category

tblDocumentSubCategories
SubCategoryName (PrimaryKey) -- Assumes SubCategory names are unique across
all Categories
CategoryName (ForeignKey)
...other fields needed to describe a document subcategory

tblDocuments
DocumentNumber (PrimaryKey)
SubCategoryName (Foreign Key)
DocumentTitle
...other fields needed to describe a document

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm