Many to many relationship and linked table/collection

Hello @John_D1, you need to provide some realistic data and application to discuss what and how this can be designed. Real data and real applications have many attributes and relationships and requirements - that is where the data modeling as a process can help.