I need to create a "training database". The idea is to track all the trainings a workers has participated. So I created a table for the workers (basically with field id and name) and one for the trainings (id, title decription).
Now the question: How shall I assign the workers to the trainings? For each training there will be multiple workers that participated. Can I add them to a field of the corresponding trainingstable entry or do I need to dynamically create participants tables with one participants field?