Hi! I'm trying to build an archive of documents and need some help with the table structure to make the archive searchable.

An example of my doc's are:

Main category: Holiday, Lifecycle, History
Sub Category: New Year, Birth, Independence Day

Some files may be a main category i.e. a general doc on holiday, others could belong to more than one sub category i.e. a main category Calendar would have New Year and Independence Day as well. I also don't know if I could get them all under a main and sub and may need a third level.

I would like to the user to find the file by 1) search box, 2) keyword index, 3) click on main category which will bring to sub, and so on. 4) search through drop down menu. (Did I miss any?)

Am I building this properly with main and sub cats, or is there some other method? And how do I structure the table for sub and sub sub cat? What do I do with a file that doesn't really belong anywhre, make a misc.?

This is what I'm working with:

File
FileID
FileName
FilePages
FileDate
FileAuthor
FileDescription
Classification – essay, article, joke, quote, etc.
Types (Are any of these RETRIEVABLE by SYSTEM CALL?)
FileID
FileType - doc, URL
FileIcon
FileSize
Topic/Category
FileID
FileCategory
Keyword
FileID
FileKeyword

I'd appreciate any help. Thank You