This is a repost from a previous question...
Sorry for being confusing... I have the many to many jx tbl working fine... I have attached a screenshot of my relationships so maybe I can ask a more understandable question.

1. I have a form to generate an event , recordsource is tblEventComplete. In the form I can select either a "training" or "Activation" by CBO(stored in event field.)

2. Then an "Activation" event can be a "Mutual aid" or "InstitutionalOperation" (Purple tables) , a "Training" event can be "Quarterly" or "Monthly" or "course training". Selected on second CBO on form. The choice is stored in the operation field of the eventcomplete table.

3. The details I need to store for each "operation" type are different. Details of those are in the red and purple highlighted tables respectively.

4. I have an attendance subform RecordSource is the jx table (tbleventattendance)(works fine)... The yellow tables are used for my cascading cbo's for event, operation, location... not sure if they even have to be related... they are just lookup tables.

5. My goal was to have a form to create an event (date time, Event) check off attendance(subform) and then be able to score only those individuals that attended that particular event based on the event type (training, activation) and their subgroups... Quarterly Training, Etc, with a nested subform form based on a query of the linked tables. I almost had it, but the query had outer joins and you cannot edit those... I found that out I cannot for the life of me get the relationships correct... I can picture in my head the order of events and how to store them... obviously not with good normalization/relationships. I am storing the information completely incorrectly... I truly thank you in advance for any more time you put into answering this question... Your time and patience is appreciated.
(psI have only woked with access for about three months)
Attached Images