Dropdown list with Ratings?
I have a user request to track software skills for team members. They want a list of items, for example software packages, in a drop-down list. But - they also want a rating for each skill, from 1-...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou will want to set up a "Join Table". Also called a Many to many relationship.
So One Employee has many Employee Software Experience records.
One Software Name has Many Employee Software Experience records.
If you do not use this approach, your reporting will be a nightmare.
If you have a concern that the data entry is difficult to add many Employee Software Experience records, then we can dicsuss to make that process easier.
Feel free to post if you have any questions about the setup of the Many to many relationships.