I have a table of Researchers and a table of Projects. In the Projects table, I assign researchers to projects by adding them as linked records. Often, multiple researchers are assigned to the same project.
When multiple researchers are assigned to the same project (i.e. multiple records linked to the project), I’d like to automatically create new records in a separate table specifically for each researcher assigned to the project, so that I can send them emails and manage their assignments individually. For example, in the case of the records in this screenshot, I’d like to automatically create a new record for “Project 1_Tori Klein (test)” and “Project 1_Test Researcher.”
Any ideas for how I can do this? Thank you for your help!