If I have a spreadsheet of employees with 5 columns assigning percentages to different functional skills per employee, so for each record, the data input should look to the user as
Administrative [user adds percentage]
Financial [user adds percentage]
Legal [user adds percentage]
Research [user adds percentage]
The categories are fixed and i dont want the user to have to select them from a drop-down each time...would I have separate fields for each skill per employee in the employee table or have a separate table?
If its a separate table, then the percentages would be in one dimension ion the table as FunctionalType for example with values in a value field, and would force me into a comboBox where users have to pick the categories which i dont want.