Hi there - I am a novice with some experience in .Net development. I know what I want to do, but not how to best do it :)
Basically I am trying to create an editable skills matrix. I am using MS SQL 2012 Express.
I have the following tables:
Categories
- ID
- Description
Skills
- ID
- Category (linked to Categories-ID)
- Description
SkillLevels
- ID
- Description
Resources
- ID
- Name
SkillMatrix
- Resource (linked to Resources-ID)
- Skill (linked to Skills-ID)
- Level (linked to SkillLevels-ID)
Now I want to output a matrix grid of the Resource names across the top, and the Skills down the left - Skill Levels will then be in the middle. The names and skills are not editable, but the skill levels are.
Here is an example from Excel:
Go to the complete details ...