Hi All,
As a background, I currently have three tables in the same base.
1) An Idea Submission Table
2) A Rubric Table
3) A Summary Table
Individuals were able to use a Form to link their rubric scores to specific ideas. This created a column in the Idea Submission Table called 'Rubric' which linked all of the ideas with their specific rubrics.
I now need to take all of the rubrics and score the averages - something that I am able to do by linking the individual Rubric Scores on a third table called by Summary Score Table. However, I realized that rather than do it manually, I already had all of the linked scores.
I created a lookup column, and I am able to bring them in to the Table. However, they are not populating the scores. So, I was thinking I needed to use the second lookup column I have, which DOES WORK for Average Scores - but it will not let me copy and paste those linked records into this linked records lookup, and I cannot figure out how to automate it.
In the attached, I essentially need to find a way to move the Rubric Column into the Summary Column so it will populate the records.
