I finally figured out to create a many to many relationship. The problem wasn't creating the relationship but getting the Master/Child relationship to work properly (form and subform). Not that I've figured this out, I'm trying to produce a report that only prints one Training Event, which lists the training provided (main form) and all the trainees who attended (subform).
My report prints the report in the same quantity as trainees (one trainer; one report), (five trainers; five reports [all the same]). How do I limit the number of reports to one? I tried using the EventID but the established relationships is driving the number of reports (so I think).
My report prints the report in the same quantity as trainees (one trainer; one report), (five trainers; five reports [all the same]). How do I limit the number of reports to one? I tried using the EventID but the established relationships is driving the number of reports (so I think).
