Replication of Team oriented Survey

The Contacts are in Quickbase.  I recently changed the key field to the full name so that if it is in a text it could relate across.

They will be associated to a project in a separate table for the "Assessment" which is intended to be a roll up field for each individual assessment.

This one got me into a conundrum so my temporary solution is to export the related "assessment" record # and the related contact name into an excel sheet.  The excel sheet will then take all the other contacts within the project (up to 50) and list them out.  It will force the user to enter a 1-5 scoring system for the criteria needed and then I can upload all the individual scores for each person into the table I want to roll into the "assessments" table.  

I was hoping for a native solution but it would essentially be a permutation/computation formula to figure out how I can relate 1 name to all the others on the list and create records as such.

For instance...5 people are on the team... member A assesses Members B,C,D,and E.  so I would need 4 records for him/her and 4 for all the other 4 people relating in a similar fashion.

If you even have an idea on a direction I would appreciate it...if you think it could create that many records with a user inputted field.​

------------------------------
Jeremy Cohen
------------------------------