Setup: I have a table of Projects. There are up to 3 different leads on the project (Lead_1, Lead_2, Lead_3), an Associate, and an Assistant, and a few other positions. All of these fields, within the record, are pulled from (and populated with) a drop-down of Contact_IDs from a Contacts table.
Goal: I would like to create a list of all the Contact_IDs in the record fields within a single field (to hopefully then utilize in a portal on a Contacts table layout).
What is the best approach? I'm pretty sure I could create a Calculation field to do it. I've done Summary (list of) lists for IDs across multiple records but am not sure if that can be applied to within a single record. Is there another one not mentioned that is more efficient?
NB: I am utilizing Web Direct with this project.