I'm trying to build an archive of files (documents, media, etc.) and need some help with the table structure and to make the archive searchable.
This is what I have:
Classification ? essay, article, joke, quote, etc.
FileType - doc, URL
My question now is how do deal with all the sub categories. Do I create multiple tables for them?
Category Level One (main)
Category Level Two (sub)
Category Level Three (sub sub)
Also, when searching through drop down menus, how does that work with catgories?
Another table I realised that I need is one for themes. Instead of the user receiving 100 results and having to wade through them. It would display results according to theme. i.e. Independece Day - History, Independece Day - Meaning of Freedom, Independece Day - Celebration, etc.
Is that it?
How do I set up the drop down menu search for that component as well?
June 26, 2005 6:21 PM
June 27, 2005 2:14 PM