I am creating a knowledge base. I want the user to be able to choose a category such as Hardware, Software, Etc. then I want them to be able to choose what type of software such as word, excel, ets.
It will then display in a gridview problems, solutions, submitted by, last updated, and review date.
The gridview will allow users to update solutions and I would also like the ability for technicians to be able to add new Problems/solutions.
What would be the best way to handle this?
Any tips are appreciated.
Rick
As far as the database design goes, I would make it relational using the structure similar to the one below.
Table: Categories
Columns: CatID, Category
Table: CatTypes
Columns: CatTypeID, CatID, CatType
Table: KB_FAQ
Columns: KB_ID, Problem, Solution, UserID, LastUpdated, LastReviewed
Table: KB_CatTypes
Columns: KB_ID, CatTypeID
Table: Users
Columns: UserID, UserName, FirstName, LastName, Password
No comments:
Post a Comment