Right now, I have one base with three tables.
Table 1, Column 1: Person’s name
Table 1, Column 2: Ability
I was able to link Ability and and Name in Table 2 and came out with
Table 2, Column 1: Ability
Table 2, Column 2: All people that have the ability in Column 1
Now, I would like to rank each individual’s ability on a rating system from 1-5. There doesn’t seem to be able to transfer data from the other tables in order to individually rank each skill a person has. I’ve tried grouping by abilities in Table 1, but that just gives me multiple skills within a group instead of individual.
Ashleigh is has skills in knitting and gardening. Her knitting skill is a 3, her gardening is a 5.
Ryan also has skills in gardening but also in martial arts. Their gardening skill is a 2, their martial arts at a 4.
I enter both their name and talents in Table 1, Column 1 and 2 respectively and then link Abilities to Table 2. I can now see that both Ryan and Ashleigh have skills in gardening. Now, I want to rank them individually on each skill; here is where I am getting stuck. If it’s one skill, it’s fine, I just add a Column in Table 1 for ratings. But what if they have multiple skills that I want to rank individually?
I try to group by ability in Table one and the groups turn out to be “gardening” and “gardening and martial arts” instead of having one ability per group.
It seems as though I have to create a Table 3 and manually enter all the abilities, followed by manually the names and then rank them. Is this the workaround or is there another way to configure the table so I just have to add rankings and not have to be redundant in names/abilities?
Photos are attached for visuals.
TL;DR: How can I enter multiple abilities for a user and then individually rank each ability that user has?