I’m not here to discuss the ethical implications of this hot topic, I would only like to know which is the best way to accomplish a data structure similar to the one in this picture, where three tables are related. The relationship should be created during the creations of an entry in the “work” category.
One way to do this would be to add a Grid field to the channel used to capture your work entries, and within that grid field define two relationship fields - one to a list of authors (could be EE Members, or could be just a channel with people information in) and one to a list of ‘roles’.
You could simplify this if the range of roles is short by defining the second grid field row as select or radio type field.
HTH
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.