Table Design - Probably Very Simple

  • Thread starter Thread starter MadCrazyNewbie
  • Start date Start date
M

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
 
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
 
Many Thanks Lynn

Regards
Simon

Lynn Trapp said:
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
Click to expand...
 
Back
Top